Introduction
PARTITION BY
Revision
12. Summary

Instruction

Excellent! Let's review what we've learned in this part:

  • OVER(PARTITION BY x) works in a similar way to GROUP BY, defining the window as all the rows in the query result that have the same value in x.
  • x can be a single column or multiple columns separated by commas.

Alright. How about a short quiz?

Exercise

Press Next exercise to begin the quiz.

Console

Code editor

Result

TableConsole