现在用的语句是:但输出结果是行
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
(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')