- MariaDB数据库操作
- MariaDB表操作
- MariaDB表结构修改
- MariaDB增删改查操作
- MariaDB子句
- MariaDB聚合函数
- MariaDB连接
- MariaDB操作符
- MariaDB正则与条件
- MariaDB约束
- MariaDB导出与导入
- MariaDB权限与权限管理
聚合函数
COUNT
函数
COUNT()
函数用于返回表达式的计数/行数。
语法:
SELECT COUNT(aggregate_expression)
FROM tables
[WHERE conditions];
注:
COUNT()
函数只计算NOT NULL
值。
COUNT()
函数与Distinct
子句:
SELECT COUNT(DISTINCT student_name) AS "Number of Unique names"
FROM Students
WHERE student_name in ('Maxsu', 'Kobe');
SUM
函数
SUM()
函数用于返回表达式求和的值。
语法:
SELECT SUM(aggregate_expression)
FROM tables
[WHERE conditions];
MIN
函数
MIN()
函数用于检索表达式的最小值。
语法:
SELECT MIN(aggregate_expression)
FROM tables
[WHERE conditions];
MAX
函数
MAX()
函数用于检索表达式的最大值。
语法:
SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions];
下面是一个实例:
SELECT student_name, MAX(score) AS "Lowest Score"
FROM Students
where student_id < 10
GROUP BY student_name;
下面是上面语句的查询结果:
MariaDB [testdb]> SELECT student_name, MAX(score) AS "Lowest Score"
-> FROM Students
-> where student_id < 10
-> GROUP BY student_name;
+--------------+--------------+
| student_name | Lowest Score |
+--------------+--------------+
| Blaba | 100.0 |
| Crurry | 86.0 |
| JMaster | 91.0 |
| Kobe | 89.0 |
| Mahesh | 78.0 |
| Maxsu | 99.5 |
+--------------+--------------+
6 rows in set (0.04 sec)
AVG
函数
Avg()
函数用于检索表达式的平均值。
语法:
SELECT AVG(aggregate_expression)
FROM tables
[WHERE conditions];
或者 -
SELECT expression1, expression2, ... expression_n,
AVG(aggregate_expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n;