[Solved] Identify the error in this query:SELECT name FROM employees WHERE salary > ANY SELECT bonus FROM bonuses; | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

Identify the error in this query:

SELECT name FROM employees WHERE salary > ANY SELECT bonus FROM bonuses;

AUsing ANY instead of ALL causes syntax error.

BIncorrect use of > operator with ANY.

CSubquery should be in FROM clause, not WHERE.

DMissing parentheses around the subquery after ANY.

Step-by-Step Solution

Solution:

Step 1: Check ANY syntax
ANY must be followed by a subquery enclosed in parentheses.
Step 2: Identify missing parentheses
The query lacks parentheses around SELECT bonus FROM bonuses after ANY.
Final Answer:
Missing parentheses around the subquery after ANY. -> Option D
Quick Check:
ANY requires parentheses around subquery [OK]

Quick Trick: Always put subquery in parentheses after ANY [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: