Advertisement

Queries: The Sequel

When a Simple Query Isn’t Enough
  • Susan Sales Harkins
  • Martin W. P. Reid

Abstract

Most SQL solutions involve one SELECT or ACTION statement, but sometimes a more complex approach is needed. Subqueries, also known as subselects,and Parameter queries are both appropriate solutions in the right situations. A subquery combines two queries by embedding a SELECT statement within another. A subquery isn’t necessarily any faster than two fixed queries, but, once you start executing queries programmatically, you may find that subqueries are a bit easier to work with because you’ll need to execute only one query instead of two. In addition, some developers actually find subqueries easier to write once they’re familiar with the syntax.

Keywords

Select Statement Specific Time Period Parameter Expression Action Query Delete Statement 
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

© Susan Sales Harkins and Martin W.P. Reid 2002

Authors and Affiliations

  • Susan Sales Harkins
  • Martin W. P. Reid

There are no affiliations available

Personalised recommendations