attaboy Posted March 8, 2012 Share Posted March 8, 2012 I have a table called countries with 3 columns name, language, and population. I need to find a query that list groups of countries that have the same language so if I have 10 countries and 3 of them speak English, 2 speak German and the other countries speak unique languages my output would list the English and German speaking countries. I have to do this with a mysql query only no php. Link to comment https://forums.phpfreaks.com/topic/258503-need-to-select-groups-with-common-names/ Share on other sites More sharing options...
attaboy Posted March 8, 2012 Author Share Posted March 8, 2012 never mind I found a solution ; | +-------------------------------------------------------------------------------------------------------------- ------------------+ 1 row in set (0.00 sec) mysql> SELECT * -> FROM countries -> WHERE primary_language IN -> ( -> SELECT primary_language FROM countries -> GROUP BY primary_language -> HAVING COUNT(primary_language) > 1 -> ) -> ORDER BY primary_language; +-----------+------------------+------------+ | name | primary_language | population | +-----------+------------------+------------+ | Austrilia | English | 22851000 | | Canada | English | 34730000 | +-----------+------------------+------------+ 2 rows in set (0.00 sec) Link to comment https://forums.phpfreaks.com/topic/258503-need-to-select-groups-with-common-names/#findComment-1325102 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.