Topic 8618 min readStructured Tutorial
SQL Aggregate Functions: MIN Function Explained
Quick Answer
The SQL MIN function returns the smallest value from a specified column in a dataset. It is an aggregate function commonly used to find minimum values in numeric, date, or string columns within a table or query result.
Learning Objectives
- Understand the purpose and use of the SQL MIN function.
- Write SQL queries using MIN to find the smallest value in a column.
- Apply MIN function with GROUP BY to find minimum values per group.
Introduction
SQL aggregate functions help summarize data by performing calculations on multiple rows.
The MIN function is one such aggregate function that finds the smallest value in a column.
Finding the minimum value is essential for data analysis and reporting.
