数据库多行合并为一行

Oracle中,11G

 SELECT  wmsys.wm_concat(SKILLGROUPNAME)  --注意该过程返回数据类型与数据库属性有关 分为clob与char类型两种
   FROM TSKILLGROUP A
  WHERE A.SKILLGROUPID IN (1, 2, 3, 9, 12, 13, -1)
    AND A.SUBCCNO = 1
    AND A.VDN = 10;

 

11GR2

  SELECT
         LISTAGG(SKILLGROUPNAME, ',')  within  GROUP (order by a.skillgroupid)
    FROM TSKILLGROUP A
   WHERE A.SKILLGROUPID IN (1, 2, 3, 9, 12, 13, -1)
     AND A.SUBCCNO = 1
     AND A.VDN = 10;

 

DB2  9.7

  SELECT
         LISTAGG(SKILLGROUPNAME, ',')  within  GROUP (order by a.skillgroupid)
    FROM TSKILLGROUP A
   WHERE A.SKILLGROUPID IN (1, 2, 3, 9, 12, 13, -1)
     AND A.SUBCCNO = 1
     AND A.VDN = 10