SELECT DISTINCT pk_month ,BEFORE_X,MONTH_VALUE
FROM (SELECT PERSON_NUMBER, pk_month,pk_month "before_0",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 1
),
'yyyy-mm'
) "before_1",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 2
),
'yyyy-mm'
) "before_2",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 3
),
'yyyy-mm'
) "before_3",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 4
),
'yyyy-mm'
) "before_4",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 5
),
'yyyy-mm'
) "before_5",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 6
),
'yyyy-mm'
) "before_6",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 7
),
'yyyy-mm'
) "before_7",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 8
),
'yyyy-mm'
) "before_8",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 9
),
'yyyy-mm'
) "before_9",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 10
),
'yyyy-mm'
) "before_10",
TO_CHAR (
"ADD_MONTHS" (
TO_DATE (pk_month, 'yyyy-mm'),
- 11
),
'yyyy-mm'
) "before_11"
FROM FACT_LABOR_EMPLOYMENT_COUNT) UNPIVOT(MONTH_VALUE FOR BEFORE_X IN( "before_0",
"before_1",
"before_2",
"before_3",
"before_4",
"before_5",
"before_6",
"before_7",
"before_8",
"before_9",
"before_10",
"before_11")) ORDER BY 1,3