[Solved] What will be the output of this query?SELECT e.name FROM employees e WHERE e.salary > (SELECT MAX(salary) FROM employees WHERE department = e.department);Assuming salaries vary within departments. | SQL

SQL - Subqueries

What will be the output of this query?

SELECT e.name FROM employees e WHERE e.salary > (SELECT MAX(salary) FROM employees WHERE department = e.department);

Assuming salaries vary within departments.

ANo rows, because no salary can be greater than the max in the same department

BEmployees with salary equal to the maximum salary in their department

CAll employees, because the subquery returns NULL

DEmployees with salary greater than the maximum salary in their department

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery returns the maximum salary in the employee's department.
Step 2: Compare outer salary with max salary
No employee can have a salary greater than the maximum salary in their own department.
Final Answer:
No rows, because no salary can be greater than the max in the same department -> Option A
Quick Check:
Salary > max salary in department = no rows [OK]

Quick Trick: Salary cannot exceed max salary in same group [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?