从1个表里取出多条数据,需要按列输出,多谢

从1个表里取出多条数据,需要按列输出,谢谢!现在用的语句是:但输出结果是行SELECT(selectcount(*)fromBILL.

从1个表里取出多条数据,需要按列输出,谢谢!
现在用的语句是:但输出结果是行
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 ')