WITH t AS
(
SELECT 15533 pk_num, 1 seq, '홍길동' user_nm, 10101 user_no FROM dual
UNION ALL SELECT 15533, 2, '임꺽정', 10102 FROM dual
UNION ALL SELECT 15534, 1, '강호동', 10103 FROM dual
UNION ALL SELECT 15534, 2, '유재석', 10104 FROM dual
UNION ALL SELECT 15534, 3, '금잔디', 10105 FROM dual
)
SELECT pk_num
     , MIN(DECODE(seq, 1, user_nm)) user_nm1
     , MIN(DECODE(seq, 1, user_no)) user_no1
     , MIN(DECODE(seq, 2, user_nm)) user_nm2
     , MIN(DECODE(seq, 2, user_no)) user_no2
     , MIN(DECODE(seq, 3, user_nm)) user_nm3
     , MIN(DECODE(seq, 3, user_no)) user_no3
  FROM t
 GROUP BY pk_num
 ORDER BY pk_num
;