当前位置: 代码迷 >> Oracle管理 >> 从1个表里取出多条数据,需要按列输出,多谢
  详细解决方案

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

热度:83   发布时间:2016-04-24 06:15:42.0
从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 ')

  相关解决方案