CODEWITHSUNDEEP
sqloracle-database
Alan
Alan

Reputation: 13

Split Record into multiple column after Row_number and Partition By

I want to have my result to be displayed in 4 columns. This is how I did my coding. 

SELECT T.MT_CARD_TYP_ID,
       ROW_NUMBER() OVER (PARTITION BY T.APP_ID ORDER BY T.DT_CREATE) AS RN
FROM T_CS_FAC_CC T 
WHERE app_id = '8F9A97B0CB5349429C44F15830EDC18F';

What should I do the next step? Can someone pro help me out please?

This is how my result look

This is how my result look.

This is how I want the result look like.

This is how I want the result look like.

Upvotes: 1

Views: 135

Answers (1)

D-Shih
D-Shih

Reputation: 46239

You can try to use condition aggravated function.

SELECT app_id,
       MAX(CASE WHEN RN = 1 THEN MT_CARD_TYP_ID END),
       MAX(CASE WHEN RN = 3 THEN MT_CARD_TYP_ID END),
       MAX(CASE WHEN RN = 2 THEN MT_CARD_TYP_ID END),
       MAX(CASE WHEN RN = 4 THEN MT_CARD_TYP_ID END)
FROM (
    SELECT T.MT_CARD_TYP_ID, ROW_NUMBER() OVER(PARTITION BY T.APP_ID ORDER BY T.DT_CREATE) AS RN 
    FROM T_CS_FAC_CC T 
    where app_id='8F9A97B0CB5349429C44F15830EDC18F'
)t1
GROUP BY app_id

Upvotes: 1

Related Questions