</>
sqlintermediate

Recursive CTE - Technique 41

Recursive query traversal

sql
WITH recent_orders AS (
  SELECT customer_id, SUM(total) AS spend
  FROM orders
  WHERE created_at >= now() - interval '30 days'
  GROUP BY customer_id
)
SELECT customer_id, spend
FROM recent_orders
ORDER BY spend DESC
LIMIT 10;

Use Cases

  • database operations
  • data management

Tags

#sql#database#recursive

Related Snippets

Similar patterns you can reuse in the same workflow.

sqladvanced

Recursive CTE for Hierarchical Data

Query hierarchical data like org charts, categories, and file trees using recursive CTEs.

Best for: Querying organizational hierarchies

#sql#cte
sqlbeginner

View - Technique 1

Create and manage database views

Best for: database operations

#sql#database
sqlintermediate

Index - Technique 2

Create and optimize database indexes

Best for: database operations

#sql#database
sqladvanced

Trigger - Technique 3

Create triggers for automatic actions

Best for: database operations

#sql#database