2 ms·
Common Table Extensions are often good enough: With americans as (select ...) select from ..., americans ... https://www.draxlr.com/blogs/common-table-express
by hackandthink 4y ago
Common Table Extensions are often good enough:
With
americans as (select ...)
select from ..., americans ...
https://www.draxlr.com/blogs/common-table-expressions-and-its-example-in-postgresql/ https://www.draxlr.com/blogs/common-table-expressions-and-it...
- code_biologist 4y agoThe lack of variables is a major pain point for many devs when learning SQL. CTEs address one aspect. It's maybe not 1:1 or ideal, but lateral joins are a great way to get in-query variables and are extremely powerful for controlling cardinality! https://sqlfordevs.com/for-each-loop-lateral-join https://sqlfordevs.com/for-each-loop-lateral-join
- im3w1l 4y agoOh huh, I didn't know that was a thing. Exactly what I wanted.