Question

plsql可以执行但是在mybatis报子查询返回多行语句的错误

这是SQL:
select create_time,(select count(*) from t_inspection where insp_status = 4 group by create_time) as finishInsp from t_inspection where to_date(to_char(create_time,'yyyy-mm-dd'),'yyyy-mm-dd') <![CDATA[>=]]> (to_date(to_char(sysdate-30,'yyyy-mm-dd'),'yyyy-mm-dd')) and to_date(to_char(create_time,'yyyy-mm-dd'),'yyyy-mm-dd') <![CDATA[<=]]> (to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd'))

Answer 1

这个：
select count(*) from t_inspection where insp_status = 4 group by create_time
为什么要group by呢，确实有可能返回多行数据啊
可是你放到大的查询里，是不能出现多行的
去掉group by就行了
select count(*) from t_inspection where insp_status = 4