The MAX() Function

MAX() - This function returns the highest value in a particular column. Let's take a look at the following example:


              12
            
SELECT MAX(population) 
FROM country;

Here MAX() returns the largest population value in the country table.

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query to get the largest value from the surfacearea column in the country table.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 5. Chapter 5

MAX() - This function returns the highest value in a particular column. Let's take a look at the following example:


              12
            
SELECT MAX(population) 
FROM country;

Here MAX() returns the largest population value in the country table.

Here is the country table we are working with:

Task

Swipe to show code editor

Write an SQL query to get the largest value from the surfacearea column in the country table.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 5. Chapter 5

Switch to desktop for real-world practiceContinue from where you are using one of the options below