Introduction
LEAD and LAG
4. General syntax
FIRST_VALUE, LAST_VALUE, NTH_VALUE
Revision

Instruction

Okay! Let's introduce the general syntax for analytic functions:

<analytic function> OVER (...)

Looks familiar? That's right. Analytic functions are quite easy, their syntax is identical to aggregate functions. The difference is that aggregate functions calculate a cumulative result for all the rows in the window frame, while the analytic functions refer to single rows within the frame.

Exercise

Press Next exercise to continue.

Console

Code editor

Result

TableConsole