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.

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.

Summarizing Data

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.


Explains how to use the ROLLUP, GROUP BY, and GROUPING SETS operators, and provides some examples.