Skip to main content
SQL • LESSON 65

MIN

How can we find the lowest employee salary?

Intermediate3 Minutes780 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