SQL MAX Tutorial

SQL Tutorial: MAX Function with Example

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 ;

Example

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

How to Learn SQL

Master SQL with hands-on training. SQL is one of the most in-demand programming languages and is used across a variety of professions.

Related Resources

SQL WHERE Tutorial

This tutorial walks through the basics of the WHERE statement in SQL and an example of how to use it.

SQL MIN Tutorial

Learn the basics of the MIN function and how and when to use it in this tutorial.

SQL SELECT Tutorial

Simple Tutorial on how to use the SELECT statement in SQL

Yelp Facebook LinkedIn YouTube Twitter Instagram