Thursday, December 8, 2016

SQL query puzzle - List country and languages spoken

Given a table of country and language spoken,  fetch country and comma separated languages spoken list using a SQL query.
Given table example entries:
Country Language
India Hindi
India Kannada
India Tamil
China Mandarine
China Cantonese
 
Expected Result of SQL Query:
Country Language_list
India Hindi, Kannada, Tamil
China Madarine, Cantonese
 
constraint: no further querying is allowed from supporting objects of SQL query in question. 

SELECT COUNTRY, LISTAGG(LANGUAGE, ', ') WITHIN GROUP (ORDER BY LANGUAGE) LANGUAGE_LIST FROM COUNTRY_LANGUAGE_TABLE GROUP BY COUNTRY;
 

No comments:

Post a Comment