sql排序问题

select * from Test

select name as 员工姓名,score as 员工业绩,排名=(SELECT COUNT(DISTINCT Score) FROM Test WHERE Score >= a.score)
from Test a where score in
(
select distinct top 3 score from Test order by score desc
)
order by 员工业绩 desc
go

 

select name as 员工姓名,score as 员工业绩,排名=(SELECT COUNT(Score) FROM Test WHERE Score >a.Score) + 1
from Test a where score in       
(
select distinct top 3 score from Test order by score desc
)
order by 员工业绩 desc
go

 

SELECT *,Place=(SELECT COUNT(DISTINCT Score) FROM Test WHERE Score >= a.Score)
FROM Test a
ORDER BY Place

效果依次是：