现在用的语句是:但输出结果是行
SELECT
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '301% ' AND SI_EXTERNAL_ID NOT LIKE '%p '),
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '6020% ' AND SI_EXTERNAL_ID NOT LIKE '%p '),
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '6022% ' AND SI_EXTERNAL_ID NOT LIKE '%p ')
FROM DUAL
请帮忙!
------解决方案--------------------
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '301% ' AND SI_EXTERNAL_ID NOT LIKE '%p ')
union
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '6020% ' AND SI_EXTERNAL_ID NOT LIKE '%p ')
union
(select count(*) from BILL.T_SI_EXTERNAL_ID WHERE STATUS = 0 AND LATN_ID=634 AND SI_EXTERNAL_ID LIKE '6022% ' AND SI_EXTERNAL_ID NOT LIKE '%p ')