This article is about the EXCEPT set operator as part of the SQL syntax that USoft supports.
EXCEPT
The EXCEPT operator removes, from the outcome of the SELECT statement appearing before it, any rows that are also in the outcome of a second SELECT statement appearing after it. The two queries must yield results that exhibit the same structure. ORDER BY is allowed only as a modifier of the entire construct, ie., at the very end, not at the end of each SELECT statement.
With EXCEPT, the result is different depending on whether the first or the second SELECT statement appears first.
In USoft SQL syntax, EXCEPT is a synonym of MINUS.
Syntax
SELECT-statement-1
EXCEPT
SELECT-statement-2In the USoft platform, EXCEPT is supported in:
- the SQL Command tool.
- Subqueries in constraint SQL.
EXCEPT is not supported in the main statement of constraint SQL.
EXCEPT is not supported in Logical View SQL.
Sign up for the USoft Community