Window functions are used in SQL to perform calculations across a set of table rows related to the current row.

• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), ...read more