WITH C AS ( SELECT ... FROM T1 ) SELECT ... FROM C AS C1 INNER JOIN C AS C2 ON ...;
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Multiple instances of the CTE being aliased and referred to itself. Not possible with derived tables.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/24126/