Mysql中獲取行號

劍握在手發表於2015-01-15

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

相關文章