WITH t AS ( SELECT '김치국' 이름, 20 나이, '남' 성별 UNION ALL SELECT '김영희', 19, '여' UNION ALL SELECT '김근식', 35, '남' UNION ALL SELECT '박나리', 25, '여' ) SELECT x, y, z FROM (SELECT ROW_NUMBER() OVER(ORDER BY 이름) x , CAST(이름 AS VARCHAR) "11" , CAST(나이 AS VARCHAR) "22" , CAST(성별 AS VARCHAR) "33" FROM t ) a UNPIVOT (z FOR y IN ("11", "22", "33")) a ;