Javatpoint Logo
Javatpoint Logo

MySQL max() function

The MySQL max() function is used to return the maximum value of an expression. It is used when you need to get the maximum value from your table.

Syntax:

Parameter explanation

aggregate_expression: It specifies the column or expression, from which the maximum value will be returned.

table_name: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional. It specifies the conditions that must be fulfilled for the records to be selected.

MySQL max() function example

Consider a table named "employees", having the following data.

mysql max() 1

Execute the following query:

Output:

mysql max() 2
Next TopicMySQL first()




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA