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.

• 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.

• 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.