COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Salesman TableSID SNAME LOCATION1 Peter London2 Michael Paris3 John Mumbai4 Harry Chicago5 Kevin London6 Alex ChicagoSale TableSALEID SID SLDATE1001 1 01-JAN-141002 5 02-JAN-141003 4 01-FEB-141004 1 01-MAR-141005 2 01-FEB-141006 1 01-JUN-15Display the names of salesmen who have made at least 2 sales. (SELECT ALL THAT APPLY)
|
SELECT SNAME FROM SALESMAN S WHERE EXISTS (SELECT COUNT(SID) FROM SALE S1 WHERE S.SID=S1.SID HAVING COUNT(SID)>=2);
|
|
SELECT SNAME FROM SALESMAN S, SALE S1 WHERE S.SID=S1.SID GROUP BY SNAME HAVING COUNT(S1.SID)>=2;
|
|
SELECT SNAME FROM SALESMAN S WHERE EXISTS (SELECT COUNT(SID) FROM SALE S1 HAVING COUNT(SID)>=2);
|
|
None of the above
|
Explanation:
There is 1 question to complete.