What is use of EXCEPT Clause in SQL?

Question

Sumit Kesarwani · Answer

EXCEPT clause is similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are not returned in the second query. Each SQL statement within the EXCEPT query and MINUS query must have the same number of fields in the result sets with similar data types.

interview

What is use of EXCEPT Clause in SQL?

Can you answer this question?

1 Answers