Monday, October 26, 2015

What is the difference between a CTE and a subselect/subquery?

They are basically the same thing. A CTE has you doing a select AS and defining a variable holding the selection instead of just nesting a select inside of parenthesis.

No comments:

Post a Comment