笔记记录
SELECT * FROM (
SELECT (@rownum:=@rownum+1) AS rownum, a.* FROM `test` a, (SELECT @rownum:= 0 ) r ORDER BY a.`socre` DESC ,`createTime`
) AS b WHERE id = 1
笔记记录
SELECT * FROM (
SELECT (@rownum:=@rownum+1) AS rownum, a.* FROM `test` a, (SELECT @rownum:= 0 ) r ORDER BY a.`socre` DESC ,`createTime`
) AS b WHERE id = 1