Lesson 5 of 10

Master windows, partitions and frames

Distinguish between PARTITION BY, ORDER BY, ROWS and RANGE to avoid ambiguous indicators.

35 minSQL Data Analyst

By the end of this lesson

  • Define a partition
  • Choose a deterministic order
  • Compare ROWS and RANGE

SQL Analyst

Continue with the right access

“Master windows, partitions and frames” is included from SQL Analyst.

30 free days of SQL Pro on registration, subject to the 31 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.