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