Question

Which SQL query correctly displays all records from EMPLOYEE_CARD where Company is Reliance, Infosys, TCS, or Cognizant?

A SELECT * FROM EMPLOYEE_CARD WHERE COMPANY = 'Reliance' AND COMPANY = 'TCS';

B SELECT * FROM EMPLOYEE_CARD WHERE COMPANY IN ('Reliance','Infosys','TCS','Cognizant');

C SELECT * FROM EMPLOYEE_CARD WHERE COMPANY BETWEEN 'Reliance' AND 'Cognizant';

D SELECT * FROM EMPLOYEE_CARD WHERE COMPANY LIKE 'Reliance%Infosys%TCS%';

E SELECT * FROM EMPLOYEE_CARD WHERE COMPANY = ANY ('Reliance','Infosys','TCS','Cognizant');

More IT Operating System Questions