WHERE subject IN &#40;SELECT subject FROM sanfoundry WHERE subject_value IN &#40;3, 2&#41;&#41;;
A. {5, 6}
B. (1, 2, 3}
C. {3, 4}
D. (1, 2, 3, 4, 5, 6}
Answer:A
WHERE subject IN &#40;SELECT subject FROM sanfoundry WHERE subject_value IN &#40;3, 2&#41;&#41;;
A. {5, 6} B. (1, 2, 3} C. {3, 4} D. (1, 2, 3, 4, 5, 6}
Explanation: Only those value will be selected whose subjects are c, c++, sql, oop. In the sub query subject_value=3 OR 2 which belongs to subject {c, c++, sql, oop} after that this subject belong to intern_id (1, 2, 3, 4, 5, 6).