Suggest an editImprove this articleRefine the answer for “What do MIN() and MAX() do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`MIN()` and `MAX()` are aggregate functions that find **the minimum and maximum value** in a dataset: `MIN(column)` returns the smallest value in a column, `MAX(column)` returns the largest. **Key point:** combined with `GROUP BY`, you can show a value range by category, e.g. the minimum and maximum salary in each department.Shown above the full answer for quick recall.Answer (EN)Image`MIN()` and `MAX()` are aggregate functions that find **the minimum and maximum value** in a dataset. - `MIN(column)` returns **the smallest value** in a column; - `MAX(column)` returns **the largest value**. ### Example ```sql SELECT MIN(salary), MAX(salary) FROM employees; ``` Shows **the smallest** and **the largest salary**. You can use it with `GROUP BY`: ```sql SELECT department, MIN(salary), MAX(salary) FROM employees GROUP BY department; ``` Shows the salary range **in each department**.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.