Question

Raj is a database programmer, has to write the query from EMPLOYEE table to search for the employee who are working in „Sales‟ or „IT‟ department, for this he has written the query as: SELECT * FROM EMPLOYEE WHERE department=‟Sales‟ or „IT‟; But the query is not producing the correct output, help Raj and correct the query so that he gets the desired output

Answer 1

Answer:

SELECT * FROM EMPLOYEE WHERE department="Sales" or department="IT"