select chgdetail_id,
       chgdetail_custname
       min(decode(seq, 1, serv_devcode, NULL)) || ',' ||
       min(decode(seq, 2, serv_devcode, NULL)) || ',' ||
       min(decode(seq, 3, serv_devcode, NULL))
       chgdetail_roperatorid
  from (select chgdetail_id,
               chgdetail_custname,
               serv_devcode,
               row_number() over(partition by chgdetail_id order by chgdetail_id asc) seq
          from (select c.id chgdetail_id,
                       c.custname chgdetail_custname,
                       serv.devcode serv_devcode
                  from chgdetail c
                  left outer join serv serv on c.racctid = serv.racctid
                 where
                 group by c.id,
                          c.custname,
                          serv.devcode))
 where seq < 4
 group by chgdetail_id,
     chgdetail_custname
SQL說明：當查詢出結果的相連的數量(如上SQL只要求電話號前三位通過“，”相連)有限制或相同需求時，可用decode相連。

---------------------------------------------------------------------------------------------------------------------------------
說人之短，乃護己之短。夸己之長，乃忌人之長。皆由存心不厚，識量太狹耳。能去此弊，可以進德，可以遠怨。
http://m.tkk7.com/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------