SQL MAX Function
SQL > SQL Functions >
SQL uses the MAX function to find the maximum value in a column. The syntax for using the MAX function is,
SELECT MAX ("column_name")
For example, if we want to get the highest sales from the following table,
we would type in
SELECT MAX (Sales) FROM Store_Information;
1500 represents the maximum value of all Sales entries: 1500, 250, 300, and 700.