MySQL SQLLesson 18Free preview
MySQL MIN()
This lesson is part of MySQL · All levels
Summary
The MIN() function returns the smallest value of a column to the group of rows that is calculated. This function works on the type of numbers, text, or dates, and ignores the value NULL. It is very useful to find for example the cheapest price, the earliest date, or the lowest test score.
Key points
- Returns the smallest value on the calculated column
- Can be used for numerical type, string, date, and time
- Ignore the value of NULL when determining the minimum value
- Can be combined GROUP BY for a minimum of each group
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.