Comment on Why most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEs
AngryishHumanoid@reddthat.com 4 months ago
I imagine it depends on use case. Anything more advanced that subqueries/CTEs is largely the domain of ETL developers (not exclusively, obviously) but most others using SQL don’t need anything that advanced.