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