2 Comments
User's avatar
Scott Edwards's avatar

I was thinking the only advantage of a subquery over a CTE is that a subquery can be correlated

Expand full comment
Jess Ramos's avatar

that's a great point! That's the main reason I'd go for a subquery over a CTE

Expand full comment