MariaDB教程

MariaDB MIN()

MariaDB MIN()函数用于检索表达式的最小值。
语法:
SELECT MIN(aggregate_expression)
FROM tables
[WHERE conditions]; 
示例:

MIN()具有单个表达式的函数

我们有一个" Student"表,具有以下数据:
MariaDB Min function 1
让我们使用MIN()函数检索最低工资。
SELECT MIN(salary) AS "Lowest Salary"
FROM Student; 
输出:
MariaDB Min function 2

带有ORDER BY子句的MIN()函数

SELECT student_name, MIN(salary) AS "Lowest Salary"
FROM Student
where student_id < 10
GROUP BY student_id;
输出:
MariaDB Min函数3
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4