O'Reilly logo

Inside Microsoft® SQL Server® 2008: T-SQL Querying by Lubor Kollar Itzik Ben-Gan Dejan Sarka, and Steve Kass

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

Table Expressions

So far, I’ve covered scalar and multivalued subqueries. This section deals with table subqueries, which are known as table expressions. In this chapter, I’ll discuss derived tables and common table expressions (CTE).

More Info

More Info

For information about the two other types of table expressions—views and inline table-valued functions—please refer to Inside Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press, 2009).

Derived Tables

A derived table is a table expression—that is, a virtual result table derived from a query expression. A derived table appears in the FROM clause of a query like any other table. The scope of existence ...

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