select top1 :
1 SELECT TOP 1 * FROM SC ORDER BY score DESC
运行结果如下:
S# | C# | Score |
001 | 03 | 120 |
1 SELECT TOP 1 WITH ties * FROM SC ORDER BY score DESC
运行结果如下:
S# | C# | Score |
002 | 03 | 120 |
001 | 03 | 120 |
select top1 :
1 SELECT TOP 1 * FROM SC ORDER BY score DESC
运行结果如下:
S# | C# | Score |
001 | 03 | 120 |
1 SELECT TOP 1 WITH ties * FROM SC ORDER BY score DESC
运行结果如下:
S# | C# | Score |
002 | 03 | 120 |
001 | 03 | 120 |
转载于:https://www.cnblogs.com/amalieSmile/p/4071634.html