To filter main departments based on whether a corresponding sub-department exists in a separate table, which query syntax is appropriate?

Question

Computer Science · Database Management Systems

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT * FROM departments WHERE sub_dept IN (SELECT name FROM sub_depts);

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Database Management Systems?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Database Management Systems

Who among the following founded the 'Forward Bloc'?

Which of the following statements regarding the Harappan Civilization is NOT correct?

Which ruler is generally credited with unifying much of Northern India under a single empire for the first time?

Answer 1

SELECT * FROM departments WHERE sub_dept IN (SELECT name FROM sub_depts);

Answer 2

SELECT * FROM departments GROUP BY sub_dept;

Answer 3

SELECT * FROM departments ORDER BY sub_dept;

Answer 4

SELECT * FROM departments HAVING sub_dept IS NOT NULL;

Related Practice Questions