将几个查询结果放在一个表中

select
(select count(*) from T_CATALOG_MESSAGE t where 1=1 and t.DATA_VALID_FLAG='1' and STATE='2'
and YWTYPE in('1','2','3') and to_char(t.ins_time,'yyyy-mm-dd')='2021-08-09')bdzs,
(select count(*) from T_CATALOG_MESSAGE t where 1=1 and t.DATA_VALID_FLAG='1' and STATE='2'
and YWTYPE in('1') and to_char(t.ins_time,'yyyy-mm-dd')='2021-08-09') addSum,
(select count(*) from T_CATALOG_MESSAGE t where 1=1 and t.DATA_VALID_FLAG='1' and STATE='2'
and YWTYPE in('2') and to_char(t.ins_time,'yyyy-mm-dd')='2021-08-09') changeSum,
(select count(*) from T_CATALOG_MESSAGE t where 1=1 and t.DATA_VALID_FLAG='1' and STATE='2'
and YWTYPE in('3') and to_char(t.ins_time,'yyyy-mm-dd')='2021-08-09') QxSum
from dual;

posted on 2021-08-09 11:26  IT-QI  阅读(163)  评论(0编辑  收藏  举报