mysql MAX() function


  Translation results:

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

adv.At most

mysql MAX() functionsyntax

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() functionexample

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

Popular Recommendations

Home

Videos

Q&A