和select top 10 * from table order by sum
结果不一致。假如sum有相同的数据
这个我可以解决问题。我想问的是
比如：select top 4 * from users order by age
id age
1 24
2 34
3 0
4 0
select top 5 * from users order by age
id age
1 24
2 34
3 0
5 0
6 0
当age有相同的时候就会出现这样的情况。我就是想知道当age相同的时候sql是如何排序的
如果租启sum有重复的有可能出现不一致，你可以再增弊吵如加上唯一列来排序如碰模ID
select top 15 * from table order by sum, id
select top 10 * from table order by sum, id
这样就会相同了
select top 15 * from (select * from table order by sum);
select top 10 * from (select * from table order by sum);
select top 15 * from table order by sum desc
select top 10 * from table order by sum desc
或孝档者举慎液正物
select top 15 * from table order by sum asc
select top 10 * from table order by sum asc
一个15条，一个10条咯
不知道你问什么， top 10 和top 15 当然不一致