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.
  1. Prepare
  2. SQL
  3. Advanced Select
  4. Occupations
  5. Discussions

Occupations

  • mannu_singhal
     + 11 comments

    *Trying without PIVOT *

    Select D.Name, P.Name, S.Name, A.Name

    from

    (Select Name, row_number() over (partition by occupation order by name) id from Occupations where Occupation = 'Doctor') D

    full outer join

    (Select Name, row_number() over (partition by occupation order by name) id from Occupations where Occupation = 'Professor') P on D.id = P.id

    full outer join

    (Select Name, row_number() over (partition by occupation order by name) id from Occupations where Occupation = 'Singer') S on P.id = S.id

    full outer join

    (Select Name, row_number() over (partition by occupation order by name) id from Occupations where Occupation = 'Actor') A on S.id = A.id;