Learn the basics of the MAX function in SQL with an example and screenshots.

MAX Function

  • The MAX function is used to find the maximum value of a given column.

  • It retrieves the maximum value of a given column from our data. 

  • Syntax: SELECT MAX(column_1) FROM table ;


Let’s say we have a basketball league and we keep records of each player, which team they are on, and their basic statistics. 

Stats Table

If we wanted to use a SQL query to find the player with the most rebounds, we would write the following:

SQL MAX statement

Once we hit enter and run, our result should be as follows:

SQL MAX Result

Master SQL in hands-on training