sql 排名　并列有关问题

sql 排名　并列问题


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

[解决办法]
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