SELECT rowno FROM (select id,age,name,(@rowno:=@rowno+1) as rowno from users ,(select (@rowno:=0)) b order by age DESC ) aaa WHERE name=‘abc‘;
sql查排名
原文:http://my.oschina.net/chworld/blog/491218