Mysql中获取行号

Select UID,(@rowNum:=@rowNum+1) as rowNo 
From a, 
(Select (@rowNum :=0) ) b 
Order by a.Money Desc 

posted @ 2015-01-15 13:31  剑握在手  阅读(957)  评论(0)  编辑  收藏  举报
返回顶部↑