SQL
General-Purpose Window Functions
<div class="nostroke_table"></div>  
|   |   |
|:--|:--------|
| **Description** |Returns `expr` evaluated at the nth row (among rows with a non-null value of `expr` if `IGNORE NULLS` is set) of the window frame (counting from 1); `NULL` if no such row. |
| **Return Type** | Same type as `expr` |
| **Aliases** | `nth_value(column, 2)` |