Hacker News new | ask | show | jobs
by virgilp 1990 days ago
In theory, both forms should get optimized similarly by the DB, but the practice will likely differ from database to database, and maybe even from DB version to DB version.

There are though things that CTEs can do and sub-selects can't (e.g. WITH RECURSIVE)

1 comments

Didn't know about WITH RECURSIVE, very cool - thanks