mysql MAX() function

UK [mæks] US [mæks]

adv.At most

mysql MAX() function syntax

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

Syntax: SELECT MAX(column_name) FROM table_name

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

mysql MAX() function example

//查找 "OrderPrice" 列的最大值
SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Orders;