oracel查询多个字段

select 
(select count(*) from T_CATALOG_MESSAGE t where  1=1 and t.DATA_VALID_FLAG='1' and STATE='2' and YWTYPE!='3' and t.sqcj='1')bm,
(select count(*) from T_CATALOG_MESSAGE t where  1=1 and t.DATA_VALID_FLAG='1' and STATE='2' and YWTYPE!='3' and t.sqcj='2') ss, 
(select count(*) from T_CATALOG_MESSAGE t where  1=1 and t.DATA_VALID_FLAG='1' and STATE='2' and YWTYPE!='3' and t.sqcj='3') xz
from dual

posted on 2022-04-14 10:32 IT-QI 阅读(37) 评论(0) 编辑收藏举报