Advertisement

Common Table Expressions and Windowing Functions

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Abstract

SQL Server 2012 continues support for the extremely useful common table expression (CTE), first introduced in SQL Server 2005. CTEs can simplify your queries to make them more readable and maintainable. SQL Server also supports self-referential CTEs, which make for very powerful recursive queries.

Keywords

Recursive Query Business Question 
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

© Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles 2012

Authors and Affiliations

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

There are no affiliations available

Personalised recommendations