sql MAX() 與min函數實例教程好了下面我們先來看看sql max教程吧.
SQL MAX() 語法.
SELECT MAX(column_name) FROM table_name
下面來看個sql max實例.
Id OrderDate OrderPrice Customer 12008/11/121000Hansen22008/10/231600Nilsen32008/09/02700Hansen42008/09/03300Hansen52008/08/302000Jensen62008/10/04100Nilsen
sql語法.
SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Orders輸出的結果為2000下面我們再來看sql min函數的一個實例吧,它的語法與max 一樣的我就不寫了.SELECT Min(OrderPrice) AS LargestOrderPrice FROM Orders輸出結果為:100