这将返回排名为
rownum
SELECt @rownum := @rownum + 1 rownum, t.* FROM (SELECt @rownum:=0) r, (SELECT * FROM students ORDER BY gpa DESC) t;
这将返回排名为
rownum
SELECt @rownum := @rownum + 1 rownum, t.* FROM (SELECt @rownum:=0) r, (SELECT * FROM students ORDER BY gpa DESC) t;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
