SQL Window Functions

WHAT IS A FUNCTION?

A named block of code which returns same value when it is called, using the same argument. – WINDOW Functions / Analytic Functions

ROW_NUMBER

RANK

DENSE_RANK

LEAD

LAG

FIRST_VALUE

LAST_VALUE

NTH_VALUE

NTILE

Not used much

CUME_DIST

PERCENT_RANK