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:
Task
Swipe to start coding
Write an SQL query to get the smallest value from the surfacearea
column in the country
table.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 5. ChapterΒ 6