Manipulating Result Sets
SQL Server allows you to manipulate and control the results of queries by combining result sets and views, working with temporary result sets, producing summary reports of result sets, and sending notifications when result sets change. The following topics provide more information about these features.
In This Section
Combining Results Sets with UNION
Explains how to combine the results of two or more SELECT statements into a single result set.
Performing Semi-Joins with EXCEPT and INTERSECT
Explains how to compare the results of two or more SELECT statements and return distinct values.
Using UNION, EXCEPT and INTERSECT with Other Transact-SQL Statements
Provides guidelines for when you use UNION, EXCEPT, and INTERSECT with other Transact-SQL statements.
Using Common Table Expressions
Explains how to work with table-valued expressions in a query.
Introduces the tools that programmers can use to perform multidimensional analysis of SQL Server data.
Using Partitioned Views
Introduces the use of views that split data from a large table across one or more servers.
Using Query Notifications
Explains how to program an application to respond to changes in query results.
Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS
Explains how to use the ROLLUP, GROUP BY, and GROUPING SETS operators, and provides some examples.