MySQL嵌套查询语句

最新推荐文章于 2024-09-30 20:44:31 发布

weixin_34309435

最新推荐文章于 2024-09-30 20:44:31 发布

阅读量2.2k

点赞数

文章标签：数据库 c#

原文链接：http://blog.51cto.com/9447803/2408441

版权

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)

转载于:https://blog.51cto.com/9447803/2408441