Sqlite教程

SQLite MIN

SQLite MIN函数用于获取表达式的最小值。
语法:
SELECT MIN(aggregate_expression)
FROM tables
[WHERE conditions]; 
将Min函数与GROUP BY子句一起使用时的语法:
SELECT expression1, expression2, ... expression_n
MIN(aggregate_expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, ... expression_n; 
示例1:
我们有一个名为" STUDENT"的表,其中包含以下数据:
Sqlite Min function 1
从"学生"表中检索学生的最低费用:
SELECT MIN(FEES) AS "Lowest Fees"
FROM STUDENT; 
输出:
Sqlite Min函数2
示例2:
将GROUP BY子句与MIN函数一起使用:
从表" STUDENT"中检索名称和最低费用,并按名称对数据进行ORDER BY:
SELECT NAME, MIN(FEES) AS "Lowest Fees"
FROM STUDENT
WHERE ID <= 5
GROUP BY NAME; 
输出:
Sqlite Min函数3
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4