oracle把一列数据按一行来显示sql语句:
Select Ltrim(Max(Sys_Connect_By_Path(to_char(sdate,'yyyy-mm-dd'), ',')), ',') sdate
From (Select sdate,
Min(sdate) Over() Minservicetype,
(Row_Number() Over(Order By sdate)) Numid
From ecc_oms.date_week_year where haier_year = '2012'
and haier_sweek_to_year between 5 and 5)
Start With sdate = Minservicetype
Connect By Numid - 1 = Prior Numid
//Sys_Connect_By_Path()函数主要作用是可以把一个父节点下的所有子节点通过某个字符进行区分,然后连接在一个列中显示 .
本文来自:http://hi.baidu.com/likecht/item/2391154e5f2796ec1e19bce5