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.
- Prepare
- SQL
- Advanced Select
- Occupations
- Discussions
Occupations
Occupations
Sort by
recency
|
2138 Discussions
|
Please Login in order to post a comment
My Solution:
) as PO
My solutions (MySQL). hope it helps!
First approach: using CTE
Second approach: using subquery
MySQL: with ranked as (select name, occupation, row_number() over (partition by occupation order by name) as rn from occupations )
select max(case when occupation = 'Doctor' then name end) as Doctor, max(case when occupation = 'Professor' then name end) as Professor, max(case when occupation = 'Singer' then name end) as Singer, max(case when occupation = 'Actor' then name end) as actor From Ranked Group by rn Order by rn