sqlserver with ties 发表于 2014-06-03 由 小样儿 sql经典~如何快速查找考试前三名人员的姓名 select top 3 with ties * from people order by chengji desc select top 3 with ties chengji, name from people order by chengji desc