What is the EXCEPT clause?

What is the EXCEPT clause?

EXCEPT clause is a basically use on the oracle, It is similar to MINUS Operation which is also use in Oracle. Both are queries are 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 should have the same no and also have a same result sets and same data types.

Date:2012-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher