Learn the basics of the MAX function in SQL with an example and screenshots.
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.
If we wanted to use a SQL query to find the player with the most rebounds, we would write the following:
Once we hit enter and run, our result should be as follows: