5 Practical SQL CTE Examples

Just heard about CTE (Common Table Expressions). They are a feature of SQL. Not sure whether all SQLs or just Postgres. A way to refactor a complicated SQL statement into substagements.

• Web site excerpt: In this article, we’ll go through several examples to see how SQL CTEs can help you with complex calculations and hierarchical data structures.

• Link to site: 5 Practical SQL CTE Examples