Easy Tutorial
❮ Sql Insert Sql Exists ❯

SQL MAX() Function


MAX() Function

The MAX() function returns the maximum value of the specified column.

SQL MAX() Syntax


Demo Database

In this tutorial, we will use the tutorialpro sample database.

Below is the data from the "Websites" table:

+----+--------------+---------------------------+-------+---------+
| id | name         | url                       | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1  | Google       | https://www.google.cm/    | 1     | USA     |
| 2  | 淘宝          | https://www.taobao.com/   | 13    | CN      |
| 3  | tutorialpro.org      | http://www.tutorialpro.org/    | 5000  | CN      |
| 4  | 微博          | http://weibo.com/         | 20    | CN      |
| 5  | Facebook     | https://www.facebook.com/ | 3     | USA     |
|  6 | 百度         | https://www.baidu.com/    |     4 | CN      |
|  7 | stackoverflow | http://stackoverflow.com/ |     0 | IND     |
+----+---------------+---------------------------+-------+---------+

SQL MAX() Example

The following SQL statement retrieves the maximum value from the "alexa" column of the "Websites" table:

Example

SELECT MAX(alexa) AS max_alexa FROM Websites;

Executing the above SQL results in the following:

❮ Sql Insert Sql Exists ❯