select ROWNUM=(select sum(1) from member where member_mark>=a.member_mark), member_id,member_mark from member a order by ROWNUM 正确的结果应该是 mopaco 是第2名才对 1,老李 ,100 3,mopaco ,90 3,taotao3166,90 6,跑车 ,70 6,ceagle ,70 6,小崔 ,70
这个是我自己的答案 是同学想的
select 名次=(select sum(1) from member where member_mark>a.member_mark or member_id=a.member_id),
member_id,member_mark
from member a order by 名次
这个是我自己的答案 是同学想的
select 名次=(select sum(1) from member where member_mark>a.member_mark or member_id=a.member_id),
member_id,member_mark
from member a order by 名次