选择将返回新位置列的查询

Question

H guys

I just need a select query which will have return new position column in it i.e

i want the result to be

id       score     position
23       345       1
09       309       2
12       123       3

I tried this but didn't work

(SELECT @rownum := @rownum + 1 AS position,
                           id, 
                           score  
                           FROM tabs 
                           ORDER BY score DESC");

position row was empty, please help using php

Answer 1

SELECT @rownum := @rownum + 1 AS position,
id, 
score  
FROM tabs, (SELECT @rownum:=0) AS initrownum
ORDER BY score DESC