Mysql中获取行号

SELECT 
  @rownum:= @rownum + 1 AS rownum,
  name,
  score
FROM
  (SELECT @rownum := 0) t,`t_demo`
ORDER BY
  score DESC;