[Solved] Find the error in this SQL query:SELECT department, MAX(salary) FROM employees GROUP BY department HAVING salary > 50000; | SQL

SQL - GROUP BY and HAVING

Find the error in this SQL query:

SELECT department, MAX(salary) FROM employees GROUP BY department HAVING salary > 50000;

AUsing column 'salary' in HAVING without aggregation

BGROUP BY clause is missing

CMAX() function cannot be used in SELECT

DHAVING clause should be replaced with WHERE

Step-by-Step Solution

Solution:

Step 1: Check HAVING clause usage
The HAVING clause filters groups based on aggregate results or grouped columns.
Step 2: Identify invalid reference
The query uses salary directly in HAVING, but salary is neither aggregated nor grouped.
Step 3: Correct usage
The condition should use an aggregate function like MAX(salary) > 50000 in HAVING.
Final Answer:
Using column 'salary' in HAVING without aggregation -> Option A
Quick Check:
HAVING must use aggregates or grouped columns [OK]

Quick Trick: HAVING needs aggregates or grouped columns [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this SQL query: