could anyone please share a query using the 'in' operator? | SoloLearn: Learn to code for FREE!

+1

could anyone please share a query using the 'in' operator?

sql

2/16/2016 10:18:24 AM

Nirab Gouda

3 Answers

New Answer

+1

SELECT *FROM CUSTOMERS WHERE CITY IN('LOS ANGELES','NEW YORK');

+1

SELECT * FROM CUSTOMER WHERE ID IN (SELECT DISTINT(CUSTOMERID) FROM ORDERS)

0

SELECT * FROM SDET WHERE TOOL IN ('MFG123', 'MFG245', 'MFG300') AND TESTDATE BETWEEN '04/23/2016' TO '05/02/2016'