Skip to main content
SQL โ€ข LESSON 65

MIN

How can we find the lowest employee salary?

Intermediateโฑ 3 Minutesโญ 780 XP
๐Ÿค” THE QUESTION

How can we find the lowest employee salary?

๐Ÿ’ก WHAT IS IT?

MIN() identifies the smallest numerical, alphabetical, or chronological value in a column.

๐ŸŽฏ WHAT IS IT USED FOR?

Minimum wage baselines, earliest transaction timestamps, lowest product prices.

๐Ÿ’ป EXAMPLE
SELECT MIN(salary) AS minimum_salary
FROM employees;

๐ŸŽฏ Mission Objectives

Practice typing production-grade SQL code for MIN.

  • โœ“ MIN() function
  • โœ“ Lowest value
  • โœ“ Boundary analysis
  • โœ“ Statistical baselines