WINDOW

Syntax

WINDOW ( from[, from_type], to[, to_type][, <relation>][, <orderBy>][, <blanks>][, <partitionBy>] )  

About Window functions:

Before jumping into the offset function, lets learn about what window functions are and how they work and exemplify it with the WINDOW function.