WHAT IS USE OF EXCEPT CLAUSE IN SQL?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1090  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is use of EXCEPT Clause in SQL?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!