Aller au contenu principal

Sort Window Clauses by the Question They Answer

Categorize common window-function ingredients by whether they define peers, sequence, or visible rows.

sql-advanced5 min read

Place each SQL fragment in the bucket that matches the question it answers. Defines the peer set Defines the sequence Defines visible rows partition by customer_id partition by region, month_start order by event_at, event_id order by revenue desc rows between unbounded preceding and current row rows between unbounded preceding and unbounded following

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Nous contacter