SQL Window Functions Helper
By n o a h · Published · Updated
Design SQL queries using advanced window functions for analytic tasks.
Tags: coding, database, sql
Prompt template
## Introduction Generate SQL queries using partition, lag, lead, and ranking window functions. ## Query Details - Table Name: [text: e.g., employee_salaries] - Target Operation: [dropdown: Running total, Rank/Denserank, Lead/Lag comparison, Moving average] - Partition Field: [text: e.g., department_id] - Order Field: [text: e.g., salary]