mysql MIN() function

英[ˈmɪn 　　美[ˈmɪn] 　　

adj. Small, tiny

n. Miniature copy; miniature model; miniature painting; miniature portrait painting

vt. Make it small; draw... into a slender picture; abbreviation

mysql MIN() function syntax

Function:Return the minimum value in a column. NULL values are not included in the calculation.

Syntax:SELECT MIN(column_name) FROM table_name

Notes:MIN and MAX can also be used for text columns to get the Highest or lowest value in alphabetical order.

mysql MIN() function example

//查找 "OrderPrice" 列的最小值 SELECT MIN(OrderPrice) AS SmallestOrderPrice FROM Orders;