DB2,实现查询结果中多行字段合并到一行上的SQL语句写法 ?答:t1 (id, DEPTNO, SEX, ENAME) AS (SELECT ROW_NUMBER() OVER(PARTITION BY DEPTNO, SEX ORDER BY ENAME) AS ID,DEPTNO,SEX,ENAME FROM temp ),t2 (id, DEPTNO, SEX, ENAME) AS (SELECT t1.id,t1.DEPTNO,t1.SEX,CAST(t1.ENAME AS varchar(100)) AS ENAME FROM t1 WHERE t1.id = 1...