SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectQuery-Based Questionsm3 partitioning lifecycle

Partition Metadata-Driven Retention SQL

Write SQL command pattern to remove data older than 2024-01-01 via partition operation (not row delete).

Schema Context

events partitioned by month on event_time