请教以下oracle问题？

[调活]

select /*+ parallel(a,8) */ a.identityid,a.createtime LAST_LOGIN_TIME,
(case when accounttype = 2 then accountname end) EMAIL,
(case when accounttype = 3 then accountname end) TELEPHONE,
from fileinter.TB_D_USECENTER_ACCOUNT_INFO a where a.identityid='305840012'
group by a.identityid,a.createtime,(case when accounttype = 2 then accountname end),(case when accounttype = 3 then accountname end)


表中数据结构是这样
identityid createtime accountname accounttype
123 sysdate jiaxiuya 1
123 sysdate 123123 2

我想合并成下面这样
identityid createtime EMAIL TELEPHONE
123 sysdate jiaxiuya 123123


请问上述语句如何修改？

[调活]

我只能想到这样解决 select identityid, LAST_LOGIN_TIME, wmsys.wm_concat(a.email) email, wmsys.wm_concat(a.telephone) telephone from (select /*+ parallel(a,8) */ a.identityid,a.createtime LAST_LOGIN_TIME, (case when accounttype = 2 then accountname end) EMAIL, (case when accounttype = 3 then accountname end) TELEPHONE, from fileinter.TB_D_USECENTER_ACCOUNT_INFO a where a.identityid='305840012' group by a.identityid,a.createtime,(case when accounttype = 2 then accountname end), (case when accounttype = 3 then accountname end))b group by identityid LAST_LOGIN_TIME

[治数有道]

WITH TT AS
(SELECT '123' AS A, 'sysdate' AS B, 'jiaxiuya' AS C, 1 AS D
FROM DUAL
UNION ALL
SELECT '123' AS A, 'sysdate' AS B, '123123' AS C, 2 AS D FROM DUAL)
SELECT A, B, MAX(CASE WHEN D = 1 THEN C END) AS EMAIL, MAX(CASE WHEN D = 2 THEN C END) AS PHONE
FROM TT
GROUP BY A, B

[调活]

引用 2 楼 ytoms 的回复:

WITH TT AS (SELECT '123' AS A, 'sysdate' AS B, 'jiaxiuya' AS C, 1 AS D FROM DUAL UNION ALL SELECT '123' AS A, 'sysdate' AS B, '123123' AS C, 2 AS D FROM DUAL) SELECT A, B, MAX(CASE WHEN D = 1 THEN C END) AS EMAIL, MAX(CASE WHEN D = 2 THEN C END) AS PHONE FROM TT GROUP BY A, B

非常感谢，数据库新手