sql ranking side by side problem

imadogdog

select ROWNUM = (select sum (1) from member where member_mark> = a.member_mark),
member_id, member_mark
from member a order by ROWNUM

The correct result should be that mopaco is second.


1, Lao Li, 100
3, mopaco, 90
3, taotao3166,90
6, sports car, 70
6, ceagle, 70
6, Xiao Cui, 70

116657396

select
    ROWNUM = isnull ((select count (*) from member where member_mark> a.member_mark), 0) +1,
    member_id,
    member_mark
from
    member a
order by
    ROWNUM

朗基奴斯

select ROWNUM = (select sum (1) +1 from member where member_mark> = a.member_mark),
member_id, member_mark
from member a order by ROWNUM

haigerrual

Ok
There are actually other solutions
learned

imadogdog

This is my own answer

select rank = (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

liyantz

select ROWNUM = (select count (DISTINCT member_mark) from member where member_mark> = a.member_mark),
member_id, member_mark
from member a order by ROWNUM