select top 1 和select top 1 with ties * from SC 的区别

select top1 :

 SELECT TOP 1 * FROM SC ORDER BY score DESC 

运行结果如下：

sc表数据查询select top 1

S#	C#	Score
001	03	120

 

 

 

SELECT TOP 1 WITH ties * FROM SC ORDER BY score DESC  

 运行结果如下：

S#	C#	Score
002	03	120
001	03	120