Introduction
ROWS
9. Rows - exercise 2
RANGE
Default window frame
Revision

Instruction

Okay, let's try one more.

Exercise

For each product, show its id, name, introduced date and the count of products introduced up to that point.

Stuck? Here's a hint!

You may use ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.

Console

Code editor

Result

TableConsole