MySQL嵌套查询语句

SELECT District,NAME,Population FROM city WHERE Population IN (SELECT MIN(Population) FROM city 
WHERE city.CountryCode=‘CHN‘
GROUP BY city.District)
UNION
SELECT District,NAME,Population FROM city WHERE Population IN (SELECT MAX(Population) FROM city 
WHERE city.CountryCode=‘CHN‘
GROUP BY city.District)

MySQL嵌套查询语句

原文：https://blog.51cto.com/9447803/2408441