O'Reilly logo

Inside Microsoft® SQL Server™ 2005: T-SQL Querying by Dejan Sarka, Lubor Kollar, Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Set Operations

You can think of joins as horizontal operations between tables, generating a virtual table that contains columns from both tables. This section covers vertical operations between tables, including UNION, EXCEPT, and INTERSECT. Any mention of set operations in this section refers to these vertical operations.

A set operation accepts two tables as inputs, each resulting from a query specification. For simplicity’s sake, I’ll just use the term inputs in this section to describe the input tables of the set operations.

UNION returns the unified set of rows from both inputs, EXCEPT returns the rows that appear in the first input but not the second, and INTERSECT returns rows that are common to both inputs.

ANSI SQL:1999 defines native operators ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required