ORACLE GROUP BY 和ORDER BY同时使用的有关问题
ORACLE GROUP BY 和ORDER BY同时使用的问题
select box_num,
(select IN_STOCK_TIME
from TMM0011
where box_num = a.box_num
and IN_STOCK_MODE ='H2'
and rownum=1
and box_num <> ' '
group by IN_STOCK_TIME
order by IN_STOCK_TIME desc) IN_STOCK_TIME
from tsosd02 a
where a.box_num <> ' '
这段执行总是报错，报错信息为：ORA-00907 缺失右括号
请问是什么原因？
------解决方案--------------------
括号里面不能用 order by
------解决方案--------------------
楼上正解，子查询不能用order by
select box_num,
(select IN_STOCK_TIME
from TMM0011
where box_num = a.box_num
and IN_STOCK_MODE ='H2'
and rownum=1
and box_num <> ' '
group by IN_STOCK_TIME
order by IN_STOCK_TIME desc) IN_STOCK_TIME
from tsosd02 a
where a.box_num <> ' '
这段执行总是报错，报错信息为：ORA-00907 缺失右括号
请问是什么原因？
------解决方案--------------------
括号里面不能用 order by
------解决方案--------------------
楼上正解，子查询不能用order by