使用with ties查询并列的数据

select top 1 with ties name,stuId,sex,score from stuInfo order by score desc