select totalmark
,(select count(*) from QualifyAuditView where totalmark>a.totalmark)+1 as 排名
from QualifyAuditView a
order by totalmark desc
select totalmark,(select count(distinct totalmark) from QualifyAuditView where totalmark>a.totalmark)+1
from QualifyAuditView a
order by totalmark desc