Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ename, count(language), LISTAGG(language, ', ') as "languages"
- FROM table_A
- GROUP BY ename
- HAVING count(language) = (SELECT max(count(language)) from table_A group by ename);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement