Home > DeveloperSection > Interviews > What is use of EXCEPT Clause in SQL?

Posted on    August-21-2014 12:07 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  823  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    August-21-2014 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick