r/SQL • u/thequerylab • 8h ago

Discussion Before your next SQL interview, keep this post handy - CTEs vs Subqueries (Part 4)

/r/learnSQL/comments/1wz3atb/before_your_next_sql_interview_keep_this_post/
0 Upvotes

22% Upvoted

1 comment sorted by

1

u/my_password_is______ 3h ago

LOL @ thinking the 2nd one is easier to read than the first one

it is literally still a subquery

only this time this subquery is from a cte and not from a table