Advertisement

Subqueries and Derived Tables

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

Subqueries are special cases of queries within queries. They eliminate the need to save data in temporary tables or variables so that it can be used in subsequent queries later in your code. They also provide you with an alternative to joins (described in Chapter 1) for obtaining the same result set. Indeed, many subqueries can be reduced to an equivalent join, as this chapter explains. The chapter also describes situations where a join won’t do and you have to go with a subquery.

Keywords

Query Plan Predicate Select Temporary Table Query Cost Query Analyzer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Itzik Ben-Gan and Tom Moreau 2000

Authors and Affiliations

  • Itzik Ben-Gan
  • Tom Moreau

There are no affiliations available

Personalised recommendations