Fundamentals of table expressions, Part 7 – CTEs, optimization considerations
SQL Performance
OCTOBER 14, 2020
Here’s the attempted solution using a CTE: WITH C AS. ( Using our trick with the TOP filter in the inner query, you prevent the unnesting of the table expression, like so: WITH C AS. ( The following code returns only shippers with a maximum order date that is on or after January 1 st , 2018: USE PerformanceV5 ; WITH C AS. (
Let's personalize your content