Subquery with MIN

How can we find employees earning the minimum salary?

Advanced⏱ 3 Minutes⭐ 1080 XP

🤔 THE QUESTION

How can we find employees earning the minimum salary?

💡 WHAT IS IT?

Subqueries with MIN() identify rows matching the lowest boundary value dynamically.

🎯 WHAT IS IT USED FOR?

Base-tier employee audits, minimum price lookups, earliest event detection.

💻 EXAMPLE

SELECT name, salary
FROM employees
WHERE salary = (
    SELECT MIN(salary)
    FROM employees
);

Practice typing production-grade SQL code for Subquery with MIN.