# Returning the Maximum Value with MAX() : MAX « Aggregate Functions « SQL / MySQL

Home
SQL / MySQL
 1 Aggregate Functions 2 Backup Load 3 Command MySQL 4 Cursor 5 Data Type 6 Database 7 Date Time 8 Engine 9 Event 10 Flow Control 11 FullText Search 12 Function 13 Geometric 14 I18N 15 Insert Delete Update 16 Join 17 Key 18 Math 19 Procedure Function 20 Regular Expression 21 Select Clause 22 String 23 Table Index 24 Transaction 25 Trigger 26 User Permission 27 View 28 Where Clause 29 XML
 SQL / MySQL » Aggregate Functions » MAX
Returning the Maximum Value with MAX()
 ```        mysql> mysql> mysql> CREATE TABLE sales_rep(     ->   employee_number INT,     ->   surname VARCHAR(40),     ->   first_name VARCHAR(30),     ->   commission TINYINT     -> ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> INSERT INTO sales_rep values(4,'Rive','Mongane',10); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO sales_rep values(5,'Smith','Mike',12); Query OK, 1 row affected (0.00 sec) mysql> mysql> SELECT MAX(commission) from sales_rep; +-----------------+ | MAX(commission) | +-----------------+ |              12 | +-----------------+ 1 row in set (0.00 sec) mysql> mysql> drop table sales_rep; Query OK, 0 rows affected (0.00 sec) mysql>                                     ```
Related examples in the same category
 1 Calculate the maximum value by using the MAX() function: MAX() 2 Get the maximum price and minimum price 3 Summarizing with MIN( ) and MAX( ) 4 What are the first and last state names, lexically speaking? 5 Use the CONCAT( ) expression with MAX( ) to find the value with the largest population part: 6 Finding Values Associated with Minimum and Maximum Values 7 Determine the population range: 8 To obtain the state name associated with the maximum population 9 Finds the size of the largest message sent between each pair of sender and recipient values listed