SQL · Functions and expressions

partition by

Restarts a window calculation for each group.

sqlRunnable example sql course

Syntax

over (partition by course order by …)

Example

Open in the lab

WITH lessons(course, minutes) AS (VALUES ('HTML', 10), ('HTML', 20), ('CSS', 5))
SELECT course, minutes, sum(minutes) OVER (PARTITION BY course) AS course_total FROM lessons;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

partition by

Example

More in this group

Learn this in the course