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 pv_dt as
(
select *, row_number() over (partition by occupation order by name) as nm
from occupations
)
select [Doctor], [Professor], [Singer], [Actor]
from pv_dt
pivot (max(name) for occupation in ([Doctor], [Professor], [Singer], [Actor])) as p;
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 →
with pv_dt as ( select *, row_number() over (partition by occupation order by name) as nm from occupations ) select [Doctor], [Professor], [Singer], [Actor] from pv_dt pivot (max(name) for occupation in ([Doctor], [Professor], [Singer], [Actor])) as p;