course content

Course Content

Introduction to SQL

The MAX() FunctionThe MAX() Function

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

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


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

Here's a short example of the country table:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 5
toggle bottom row