oracle将两个结果连接后进行查询，得到两个查询的联合结果
时间：2021-07-01 10:21:17
帮助过：4人阅读
*
from (
select count(
1) rightCount
from (
select *
from (
select *
from mic_td_exercise_push_problem mp
where mp.push_id
= 347
order by mp.create_time
desc)
where rownum
<= 3) t1
where t1.is_correct
= 1),
(select count(
1) wrongCount
from (
select *
from (
select *
from mic_td_exercise_push_problem mp
where mp.push_id
= 347
order by mp.create_time
desc)
where rownum
<= 3) t1
where t1.is_correct
= 2)
将两个查询结果进行联合查询，就得到了一条记录，两个向要的结果。
oracle将两个结果连接后进行查询，得到两个查询的联合结果
标签：
