Skip to Content
PROGRAMMING

SQL

Practical tutorials for the work we actually do. Pick one, read it in order, and apply it.

Any category Programming8 Python 2 JavaScript 2 TypeScript 3 SQL 1
Any topics Data Structures and Algorithms 1 Databases 32 Deployment and Containers 4 Performance Optimization 8 Testing and Debugging 5
Any level Advanced 1
SQL Data Structures and Algorithms Clear filters 1 result
0 likes
Walk a Tree With a Recursive CTE

Walk down an employee tree, walk up to the top, count each manager's team and guard the query against a loop with CYCLE. After this, you can query a parent-child table of any depth.

5 min read