Abstract
SQL Server 2014 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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Miguel Cebollero
About this chapter
Cite this chapter
Cebollero, M., Natarajan, J., Coles, M. (2015). Common Table Expressions and Windowing Functions. In: Pro T-SQL Programmer's Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0145-9_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0145-9_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0146-6
Online ISBN: 978-1-4842-0145-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books