Nested Select Statement (Subquery) in MySQL
Filtering records using nested SELECT query statements in WHERE and HAVING clauses.
SQL Query Statement
-- Find all employees whose salary exceeds average department salary
SELECT employee_id, first_name, salary
FROM employees e1
WHERE salary > (
SELECT AVG(salary)
FROM employees e2
WHERE e2.department_id = e1.department_id
);Expected Result / Output
+-------------+------------+----------+ | employee_id | first_name | salary | +-------------+------------+----------+ | 4 | Carol | 75000.00 | +-------------+------------+----------+ 1 row in set (0.00 sec)