Skip to content

Glossary: SQL Beyond the Basics

Frame

Also written: ROWS BETWEEN, PRECEDING, FOLLOWING

The rows a window function looks at for the current row, set with ROWS BETWEEN … AND …. For example, 2 PRECEDING AND CURRENT ROW covers this row and the two before it.

Where the book teaches it

Related terms

Moving averageWindow function