Jump to content

need to select groups with common names


attaboy

Recommended Posts

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

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)

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.