Course Content
Introduction to SQL
Introduction to SQL
The MIN() Function
MIN()
- this function returns the lowest value in a particular column.
Let's look at an example:
SELECT MIN(population) FROM country;
Here, MIN()
returns the smallest population value in the country table.
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query to get the smallest value from the surfacearea
column in the country
table.
Thanks for your feedback!
The MIN() Function
MIN()
- this function returns the lowest value in a particular column.
Let's look at an example:
SELECT MIN(population) FROM country;
Here, MIN()
returns the smallest population value in the country table.
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query to get the smallest value from the surfacearea
column in the country
table.
Thanks for your feedback!
The MIN() Function
MIN()
- this function returns the lowest value in a particular column.
Let's look at an example:
SELECT MIN(population) FROM country;
Here, MIN()
returns the smallest population value in the country table.
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query to get the smallest value from the surfacearea
column in the country
table.
Thanks for your feedback!
MIN()
- this function returns the lowest value in a particular column.
Let's look at an example:
SELECT MIN(population) FROM country;
Here, MIN()
returns the smallest population value in the country table.
Here is the country
table we are working with:
Swipe to show code editor
Write an SQL query to get the smallest value from the surfacearea
column in the country
table.