mysql 常用的聚合函数_mysql 常用聚合函数

SELECT countrycode ,SUM(population) FROM city GROUP BY countrycode;

SELECT district,SUM(Population) FROM city WHERE countrycode='chn' GROUP BY district;

SELECT countrycode,COUNT(id) FROM city GROUP BY countrycode;

SELECT district,SUM(Population) FROM city WHERE countrycode='chn' GROUP BY district HAVING SUM(Population) < 1000000 ;

where|group|having

SELECT district,SUM(Population) FROM city WHERE countrycode='chn' GROUP BY district HAVING SUM(Population) < 1000000 ;

SELECT * FROM city WHERE countrycode='CHN' ORDER BY population DESC;

SELECT district AS 省 ,SUM(Population) AS 总人口 FROM city WHERE countrycode='chn' GROUP BY district ORDER BY 总人口 DESC ;

SELECT district, SUM(population) FROM city

WHERE countrycode='CHN'

GROUP BY district

HAVING SUM(population)>5000000

ORDER BY SUM(population) DESC

LIMIT 3 ;

LIMIT N ,M --->跳过N,显示一共M行

LIMIT 5,5

SELECT district, SUM(population) FROM city

WHERE countrycode='CHN'

GROUP BY district

HAVING SUM(population)>5000000

ORDER BY SUM(population) DESC

LIMIT 5,5;

标签：city,聚合,函数,countrycode,SUM,district,mysql,GROUP,SELECT

来源： https://www.cnblogs.com/neoo9901/p/14148446.html