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