Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Summarizing, Grouping, and Sorting Query Results

ORDER BY and GROUP BY Next Page

Performing set operations on query results with UNION, INTERSECT, and EXCEPT


The operators described in this section perform set operations on the results of two or more queries. While many of the operations can also be performed using operations in the WHERE clause or HAVING clause, there are some operations that are very difficult to perform in any way other than using these set-based operators. For example:

For more information, see EXCEPT statement, INTERSECT statement, and UNION statement.


Combining sets with the UNION statement
Using EXCEPT and INTERSECT
Rules for set operations
Set operators and NULL