The MAX() Function

The SQL MAX() function returns the highest value of the selected column. The syntax:

SELECT MAX(column1) FROM table;

Here is an example. Let’s say that we want to retrive the highest value from the Products table. We can use the following SQL MAX() statement:

SELECT MAX(amount) FROM products;

This SQL statement will produce the following result:

+-------------+
| max(amount) |
+-------------+
|   120166.58 |
+-------------+