
|                                | the first row of the window frame         |
|                                | (counting from 1); null if no such row.   |
+--------------------------------+-------------------------------------------+
| LAG()                          | The value evaluated at the row that is    |
|                                | offset rows before the current row        |
|                                | within the partition; if there is no      |
|                                | such row, instead return default. Both    |
|                                | offset and default are evaluated with     |
|                                | respect to the current row. If omitted,   |
|                                | offset defaults to 1 and default to       |
|                                | null. LAG provides access to more than    |
|                                | one row of a table at the same time       |
|                                | without a self-join. Given a series of    |
|                                | rows returned from a query and a          |
|                                | position of the cursor, LAG provides      |
|                                | access to a row at a given physical       |
|                                | offset prior to that position.            |
+--------------------------------+-------------------------------------------+
| LAST_VALUE()                   | The value evaluated at the row that is    |
|                                | the last row of the window frame          |
|                                | (counting from 1); null if no such row.   |
+--------------------------------+-------------------------------------------+
| LEAD()                         | Provides access to a row at a given       |
|                                | physical offset beyond that position.     |
|                                | Returns value evaluated at the row that   |
|                                | is offset rows after the current row      |
|                                | within the partition; if there is no      |
|                                | such row, instead return default. Both    |
|                                | offset and default are evaluated with     |
|                                | respect to the current row. If omitted,   |
|                                | offset defaults to 1 and default to null. |
+--------------------------------+-------------------------------------------+
| MAX()                          | Maximum value of expression across all    |
|                                | input values.                             |
+--------------------------------+-------------------------------------------+
| MEDIAN()                       | An inverse distribution function that     |
|                                | assumes a continuous distribution model.  |
|                                | It takes a numeric or datetime value and  |
|                                | returns the middle value or an            |
|                                | interpolated value that would be the      |
|                                | middle value once the values are sorted.  |
|                                | Nulls are ignored in the calculation.     |
+--------------------------------+-------------------------------------------+
| MIN()                          | Minimum value of expression across all    |
|                                | input values.                             |
+--------------------------------+-------------------------------------------+
| NTH_VALUE()                    | The value evaluated at the row that is    |
|                                | the nth row of the window frame           |
|                                | (counting from 1); null if no such row.   |
+--------------------------------+-------------------------------------------+
| NTILE()                        | Divides an ordered data set into a        |
|                                | number of buckets indicated by expr and   |
|                                | assigns the appropriate bucket number to  |
|                                | each row. The buckets are numbered 1      |
|                                | through expr. The expr value must         |
|                                | resolve to a positive constant for each   |
|                                | partition. Integer ranging from 1 to the  |
|                                | argument value, dividing the partition    |
|                                | as equally as possible.                   |
+--------------------------------+-------------------------------------------+
| PERCENT_RANK()                 | relative rank of the current row: (rank   |
|                                | - 1) / (total rows - 1).                  |
+--------------------------------+-------------------------------------------+
| PERCENTILE_CONT()              | An inverse distribution function that     |
|                                | assumes a continuous distribution model.  |
|                                | It takes a percentile value and a sort    |
|                                | specification, and returns an             |
|                                | interpolated value that would fall into   |
|                                | that percentile value with respect to     |