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

Topic	Description
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 Common Table Expressions	Explains how to work with table-valued expressions in a query.
Summarizing Data	Introduces the CUBE, ROLLUP, and COMPUTE operators for summarizing 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.