GROUP BY 语句可结合一些聚合函数来使用,HAVING语句在GROUP BY语句后筛选数据。
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name;
常用的聚合函数
AVG():返回数值列的平均值;
SELECT AVG(column_name) FROM table_name
COUNT():返回匹配指定条件的行数;
SELECT COUNT(column_name) FROM table_name;
FIRST()/LAST() :返回指定的列中第一个/最后一个记录的值;
SELECT FIRST/LAST (column_name) FROM table_name;
MAX()/MIN() :返回指定列的最大值/最小值;
SELECT MIN/MAX(column_name) FROM table_name;
SUM() :返回数值列的总数;
SELECT SUM(column_name) FROM table_name;