[Solved] Find the error in this query:SELECT department, MAX(salary) FROM employees GROUP BY employee_id; — Ans: GROUP BY column does not match selected non-aggregated column | SQL

SQL - GROUP BY and HAVING

Find the error in this query:

SELECT department, MAX(salary) FROM employees GROUP BY employee_id;

AMAX() cannot be used with GROUP BY

Bdepartment cannot be selected with MAX()

CMissing WHERE clause before GROUP BY

DGROUP BY column does not match selected non-aggregated column

Step-by-Step Solution

Solution:

Step 1: Check GROUP BY and SELECT columns
Non-aggregated columns in SELECT must appear in GROUP BY; here department is selected but grouped by employee_id.
Step 2: Identify mismatch
This mismatch causes error because department is not grouped or aggregated.
Final Answer:
GROUP BY column does not match selected non-aggregated column -> Option D
Quick Check:
Non-aggregated SELECT columns must be in GROUP BY [OK]

Quick Trick: GROUP BY columns must include all non-aggregated SELECT 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 query: