Advertisement
Maks140888

Untitled

May 24th, 2022
754
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.18 KB | None | 0 0
  1. SELECT ename, count(language), LISTAGG(language, ', ') as "languages"
  2. FROM   table_A
  3. GROUP BY ename
  4. HAVING count(language) = (SELECT max(count(language)) from table_A group by ename);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement