为什么子查询里面使用 order by 会出错的?

[lazybone]

为什么子查询里面使用 order by 会出错的?
select * from table2
where age in (select age from table2 where age>44 order by age)order by age

[internetcsdn]

select * from table2
where age in
(select age from table2 where age>44 )order by age

在子查询里用不着用到order by 啊

[internetcsdn]

order by 在你的子查询里没有什么意义

[lazybone]

但也不应该错啊. 最多是做事画蛇添足罢了

[internetcsdn]

错误提示里好明显地提到啦,
如果你一定要用的话试下.

select * from table2
where age in
(select top 1000 age from table2 where age>44 order by age)order by age

[lazybone]

同样在子查询里面不能用 distinct 是不是这样原因?

[internetcsdn]

select * from table2
where age in
(select distinct age from table2 where age>44 ) order by age

这样可以啊