`

mysql rownum

 
阅读更多
SELECT
	@rownum :=@rownum + 1 AS rownum,
	a.*
FROM
	(SELECT @rownum := 0) r,
	compare_wall_activity_works  a
ORDER BY
	vote_number DESC

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics