1、SUM()
求和
SUM( 字段名 )
SUM( DISTINCT 字段名 ) # 去重求和
select sum(stu_age) as "AGE_SUM", sum(distinct stu_age) as "DISTINCT_AGE_SUM" from student
2、AVG()
平均值
SELECT AVG(stu_age) AS "AGE_AVG", AVG(DISTINCT stu_age) AS "DISTINCT_AGE_AVG" FROM student
3、MIN()
最小值
SELECT MIN(stu_age) AS "AGE_MIN" FROM student
4、MAX()
最大值
SELECT MAX(stu_age) AS "AGE_MAX" FROM student
5、COUNT()
计数
SELECT COUNT(stu_age) AS "AGE_COUNT", COUNT(DISTINCT stu_age) AS "DISTINCT_AGE_COUNT" FROM student