The ANSI SQL:2011 window feature provides a way to dynamically define a subset of data, or window, in an ordered relational database table. A window is specified by the OVER() phrase, which can include the following clauses inside the parentheses:
- PARTITION BY
- ORDER BY
- RESET WHEN
- ROWS