选取TOP N 时,选出平手的所有记录例如一组数据
field11 2 3 3 5 select top 3 from table得到的结果只有三个 2 3 5 而select top 3 with ties from table得到的结果有四个 2 3 3 5
field11 2 3 3 5 select top 3 from table得到的结果只有三个 2 3 5 而select top 3 with ties from table得到的结果有四个 2 3 3 5
select top 3 field1 from table得到的结果只有三个 2 3 5 而select top 3 field1 with ties from table得到的结果有四个 2 3 3 5
table
a
--
3
2
4
4
9
10select top 3 * from table order by a
2
3
4select top 3 with ties * from table order by a
2
3
4
4将返回4行 with ties列出重复值
羡慕死了..
羡慕死了..