Advertisement
Maks140888

Untitled

May 24th, 2022
654
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data Copied
Advertisement