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

+ Recent posts