Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all customers who are not also employees,which SQL keyword would you most likely use?
A)INTERSECT
B)UNION
C)EXCEPT
D)UNION ALL

Question

Quizplus · Accepted Answer

The EXCEPT keyword is used to compare two SELECT statements and returns only the distinct values from the first SELECT statement that are not present in the second SELECT statement. In this case, we can use it to select all customers from the customer table that are not present in the employee table, thus finding all customers who are not also employees.

Suppose Your Company Stores EMPLOYEE and CUSTOMER Data in Separate