SELECT id,(@rownum:=@rownum+1) AS rownum FROM test t,(SELECT @rownum:=0) r WHERE *** ORDER BY id DESC;