代碼: 選擇全部
create table test (sid int, grade int);
insert into test values (1, 15);
insert into test values (2, 50);
insert into test values (3, 26);
insert into test values (4, 80);
select sid, @rank := @rank + 1 from test a, (select @rank := 0) b order by grade desc
其他相關資料:
http://ithelp.ithome.com.tw/question/10069933