course content

Course Content

Introduction to SQL

The MIN() FunctionThe MIN() Function

MIN() - this function returns the lowest value in a particular column.

Let’s look at an example:

Explanation: Here, MIN() returns the smallest population value in the country table.

Task

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

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 6
toggle bottom row