sql中Order by 与子查询的问题？

Question

select top(5) id from Table_1 查询出的结果是 1,2,3,4,5，6select top(5) id from Table_1 查询出的结果是 1,2,3,4,5但是select id from (select top(5) id from Table_1 ) t order by t.id desc 的结果是6,5,4,3,2

Answer 1

select id from (select top(5) id from Table_1 ) t order by t.id desc   由于子查询中没有排序规则，所以会按后面的排序规则排序，如果想要得到54321 需要在子查询中加降序排序