</>
sqladvanced

Upsert - Technique 42

Insert or update rows

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

Related Snippets

Similar patterns you can reuse in the same workflow.

sqlintermediate

SQL Upsert and Merge Patterns

Insert or update records atomically using ON CONFLICT, MERGE, and database-specific upsert syntax.

Best for: Syncing data from external sources

#sql#upsert
sqlintermediate

MERGE / UPSERT Statement

Use MERGE or INSERT ON CONFLICT to upsert rows in a single statement.

Best for: Syncing data from staging tables

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