728x90

SELECT Doctor,Professor,Singer,Actor
FROM (SELECT OCCUPATION,
NAME,
ROW_NUMBER() OVER(PARTITION BY OCCUPATION ORDER BY NAME ) AS RANK
FROM OCCUPATIONS)
PIVOT
(MAX(NAME) FOR OCCUPATION IN('Doctor' AS Doctor, 'Professor' AS Professor,'Singer' AS Singer,'Actor' AS Actor)) ORDER BY RANK;
728x90