请教以下oracle问题?
调活 2015-09-19 01:17:09 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
请问上述语句如何修改?