C – Statement I is correct but Statement II is false
D – Statement I is incorrect but Statement II is true
Show Answer With Best Explanation
Answer : C Explanation: 3 tables
Question 97 UGC NET June-2020 Ques – 97: On the basis of above given table structures, retrieve the distinct employee ID (EMPID) of all employees of university who are working on project No. 20, 30 and 40.
A – SELECT EMPID FROM PROJECTWORK WHERE PROJNO=(20,30,40);
B – SELECT EMPID FROM PROJECTWORK WHERE PROJNO IN (20,30,40);
C – SELECT DISTINCT EMPID FROM PROJECTWORK WHERE PROJNO IN (20,30,40);
D – SELECT DISTINCT EMPID FROM PROJECTWORK WHERE PROJNO=20,30,40;
