MariaDB MIN()函数用于检索表达式的最小值。
语法:
SELECT MIN(aggregate_expression) FROM tables [WHERE conditions];
单个表达式函数
无涯教程有一个"Students"表，其中包含以下数据:
让无涯教程使用MIN()函数检索最低工资。
SELECT MIN(salary) AS "Lowest Salary" FROM Student;
输出:
ORDER BY MIN()函数
SELECT student_name, MIN(salary) AS "Lowest Salary" FROM Student where student_id < 10 GROUP BY student_id;
输出:
