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