sql 排名 并列问题

imadogdog

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

正确的结果应该是　mopaco 是第２名才对


1,老李      ,100
3,mopaco    ,90
3,taotao3166,90
6,跑车      ,70
6,ceagle    ,70
6,小崔      ,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

嗯
其实还有其他的解决方案
学习了

imadogdog

这个是我自己的答案　是同学想的

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 名次

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