count函数与order by子句一起查询时报错处理

来源:这里教程网 时间:2026-03-03 19:26:04 作者:

数据库版本:12.2.0.1 语句: SELECT count(*) FROM wuyangWHERE name BETWEEN 'W1' AND 'W3' OR c1 BETWEEN 'W05' AND 'W07' ORDER BY name; ERROR at line 2:ORA-03113: end-of-file on communication channelProcess ID: 78509Session ID: 15 Serial number: 1785 alter日志报错:ORA-7445 [kkoosoel] 将order by 语句去掉后,问题解决:

SELECT count(*) FROM wuyang

WHERE name BETWEEN 'W1' AND 'W3' OR c1 BETWEEN 'W05' AND 'W07';

相关推荐