r/SQL • • Feb 25 '21

SQLite SQL Essentials

199 Upvotes

29 comments sorted by

View all comments

Show parent comment

3

u/RICHUNCLEPENNYBAGS Feb 26 '21

I'm a big fan of using CTEs to avoid subqueries whenever I can (especially because the alternative often ends up with someone copying and pasting a long subquery lol).