Category: SQL

Walk hierarchies with recursive common table expressions.

Create saved queries as views for reuse and security layering.

Encapsulate multi-statement logic in stored procedures.

Create reusable scalar/table functions inside the database.

Keep all left-table rows and match right-table rows when present.

Keep all right-table rows (mirror of LEFT JOIN).

Keep rows from both sides whether they match or not.

Produce Cartesian products intentionally with CROSS JOIN.

Join a table to itself for hierarchies and pairing rows.

Combine result sets and remove duplicates with UNION.