mysql排名查询

查出排名

 

set @row_num = 0;(select *,@row_num:=@row_num+1 as n from activity_items order by num DESC limit 0,10);