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.
ms sql server query
SELECT
[Doctor], [Professor], [Singer], [Actor]
FROM
(
SELECT
Occupation,
Name,
ROW_NUMBER() OVER (PARTITION BY Occupation ORDER BY Name) AS RN
FROM
OCCUPATIONS
) AS T
PIVOT
(
MAX(Name)
FOR Occupation IN ([Doctor], [Professor], [Singer], [Actor])
) AS P
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
Beautiful Days at the Movies
You are viewing a single comment's thread. Return to all comments →
ms sql server query SELECT [Doctor], [Professor], [Singer], [Actor] FROM ( SELECT Occupation, Name, ROW_NUMBER() OVER (PARTITION BY Occupation ORDER BY Name) AS RN FROM OCCUPATIONS ) AS T PIVOT ( MAX(Name) FOR Occupation IN ([Doctor], [Professor], [Singer], [Actor]) ) AS P ORDER BY RN;