sqlcmd.net validated sql reference

Tag archive

#recursive

Commands grouped around the same concept, pattern, or recurring problem.

3 commands with this tag Browse related patterns quickly
advanced recursion MySQL MariaDB SQL Server PostgreSQL SQLite

Build A Path String While Traversing A Hierarchy

Accumulate a breadcrumb path string as a recursive CTE walks a parent-child tree.

advanced composition MySQL MariaDB SQL Server PostgreSQL SQLite

Generate a Sequence of Numbers

Produce a consecutive sequence of integers without a base table — using `generate_series` in PostgreSQL or a recursive CTE in all other engines.

advanced recursion MySQL MariaDB SQL Server PostgreSQL SQLite

Traverse Hierarchies With A Recursive CTE

Use `WITH RECURSIVE` to repeatedly join a query to its own results, enabling traversal of tree or graph structures.