Mysql 排名

SELECT id,name,num, @rownum := @rownum +1 AS ranking
FROM table t, (SELECT @rownum :=0) r where pid=15 order by num desc