Here’s the clean SQL query 👇

SELECT employee_id,

employee_name,

department_id

FROM employees

WHERE department_id IN (

SELECT department_id

FROM departments

WHERE location = 'HYDERABAD'

);

🎯 Explanation:

The subquery executes first and returns a list of department_ids

The outer query filters employees whose department_id matches that list

The subquery is non-correlated (it does not depend on the outer query)

IN is used when the subquery returns multiple values

Clean and easy to read — very common in interviews

✅ Perfect for:

✔️ SQL Interviews

✔️ Backend Developers

✔️ Java + Spring Boot Learners

✔️ Data Analysts

✔️ Reporting & Business Queries

👉 Save this post for SQL revision

👉 Follow @ashokitschool for more SQL + Java + Full Stack content

#SQLInterviewQuestions #SQLTips #INOperator #SubquerySQL #NonCorrelatedSubquery #BackendDeveloper #JavaDeveloper #AshokIT #CodingInterview #LearnSQL #DatabaseConcepts #ProgrammingTips #JobReadySkills #FullStackDeveloper

ashokitech.com/