</>
sqlintermediate

Pivot - Technique 44

Pivot row values into columns

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#pivot

Related Snippets

Similar patterns you can reuse in the same workflow.

sqlintermediate

SQL Pivot and Crosstab Queries

Transform row data into columnar reports using CASE expressions, FILTER, and crosstab patterns.

Best for: Creating monthly revenue reports

#sql#pivot
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