17,377
社区成员
发帖
与我相关
我的任务
分享
WITH a as (
SELECT '1' id ,'L&1' gd,'03-01-01' tm FROM dual UNION ALL
SELECT '1' id ,'L&2' gd,'03-01-02' tm FROM dual UNION ALL
SELECT '2' id ,'L&1' gd,'03-02-01' tm FROM dual UNION ALL
SELECT '2' id ,'L&2' gd,'03-02-02' tm FROM dual UNION ALL
SELECT '2' id ,'L&3' gd,'03-02-03' tm FROM dual UNION ALL
SELECT '3' id ,'L&2' gd,'03-03-02' tm FROM dual
)
select id,max(decode(gd,'L&1',tm)) "L&1",
max(decode(gd,'L&2',tm)) "L&2",
max(decode(gd,'L&3',tm)) "L&3"
from a
group by id;