SQL

SQL Execution Hierarchy and Early Filtering with CTEs

When writing SQL queries, we write SELECT first, sprinkle in all the necessary aggregations and joins, mostly without considering what the database executes first. In…

Hierarchical and recursive queries in SQL

Many of the datasets we touch are naturally hierarchical-category trees, nested folders, and component breakdowns. They look simple, but the moment you need to roll…