We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH ordered AS (
SELECT Name,
Occupation,
ROW_NUMBER() OVER(PARTITION BY Occupation ORDER BY Name) AS rn
FROM OCCUPATIONS
), ctc as (
SELECT * FROM (
SELECT Name, Occupation, rn
FROM ordered
) AS src
PIVOT (
MAX(Name)
FOR Occupation IN ([Doctor], [Professor], [Singer], [Actor])
) AS p
)
SELECT Doctor, Professor, Singer, Actor FROM ctc
ORDER BY rn;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Occupations
You are viewing a single comment's thread. Return to all comments →
MS SQL SERVER
WITH ordered AS ( SELECT Name, Occupation, ROW_NUMBER() OVER(PARTITION BY Occupation ORDER BY Name) AS rn FROM OCCUPATIONS ), ctc as ( SELECT * FROM ( SELECT Name, Occupation, rn FROM ordered ) AS src PIVOT ( MAX(Name) FOR Occupation IN ([Doctor], [Professor], [Singer], [Actor]) ) AS p ) SELECT Doctor, Professor, Singer, Actor FROM ctc ORDER BY rn;