sql  MAX() 与min函数实例教程好了下面我们先来看看sql max教程吧.

SQL MAX() 语法.

SELECT MAX(column_name) FROM table_name

下面来看个sql max实例.

Id
OrderDate
OrderPrice
Customer
1
2008/11/12
1000
Hansen
2
2008/10/23
1600
Nilsen
3
2008/09/02
700
Hansen
4
2008/09/03
300
Hansen
5
2008/08/30
2000
Jensen
6
2008/10/04
100
Nilsen

sql语法.

SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Orders
 
输出的结果为2000
 
下面我们再来看sql min函数的一个实例吧,它的语法与max 一样的我就不写了.
SELECT Min(OrderPrice) AS LargestOrderPrice FROM Orders
 
输出结果为:100