1. 가공전 데이타
id rowfiled
aaa 1
aaa 2
aaa 3
aaa 4
aaa 5
2. 가공후 데이타.
id filed1 filed2 filed3 filed4 filed5
aaa 1 2 3 4 5
WITH Types AS (
SELECT id , rowfiled ,VALUE
, ROWNUMBER() OVER(ORDER BY rowfiled ) AS rn
FROM (
SELECT id , rowfiled ,VALUE
FROM table_a
where idin ( '45636' , '26354' )
)
AS R
)
SELECT a.PROF_KEY
, MIN(CASE WHEN rn = 1 THEN t.value) as birthday
, MIN(CASE WHEN rn = 2 THEN t.value) as cmpname
, MIN(CASE WHEN rn = 3 THEN t.value) as cname
, MIN(CASE WHEN rn = 4 THEN t.value) as ename
, MIN(CASE WHEN rn = 5 THEN t.value) as natal
, MIN(CASE WHEN rn = 6 THEN t.value) as photourl
, MIN(CASE WHEN rn = 7 THEN t.value) as rnkcode
FROM table_a A
, Types T
WHERE A.id = t.id
and A.id in ( '11111' , '2222' )
GROUP BY a.id ;
DB2
rowfiled 필드의 세로 데이타를 가로로 만드는 방법임.