[Solved] Which of the following is the correct way to use the EXISTS operator in an SQL query? — Ans: SELECT * FROM Employees e WHERE EXISTS (SELECT 1 FROM Departments d WHERE d.id... | SQL

SQL - Subqueries

Which of the following is the correct way to use the EXISTS operator in an SQL query?

ASELECT * FROM Employees e WHERE EXISTS (SELECT 1 FROM Departments d WHERE d.id = e.department_id);

BSELECT * FROM Employees e WHERE EXISTS SELECT 1 FROM Departments d WHERE d.id = e.department_id;

CSELECT * FROM Employees e WHERE EXISTS = (SELECT 1 FROM Departments d WHERE d.id = e.department_id);

DSELECT * FROM Employees e WHERE EXISTS IN (SELECT 1 FROM Departments d WHERE d.id = e.department_id);

Step-by-Step Solution

Solution:

Step 1: Understand EXISTS syntax
The EXISTS operator requires a subquery enclosed in parentheses.
Step 2: Check each option
SELECT * FROM Employees e WHERE EXISTS (SELECT 1 FROM Departments d WHERE d.id = e.department_id); correctly uses EXISTS with a subquery in parentheses.
Options B, C, and D have syntax errors or incorrect usage.
Final Answer:
Option A -> Option A
Quick Check:
EXISTS must be followed by a subquery in parentheses [OK]

Quick Trick: EXISTS requires a subquery in parentheses [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct way to use the EXISTS operator in an SQL query?