Row-based Window

<< Click to Display Table of Contents >>

Navigation:  Glossary >

Row-based Window

Previous pageReturn to chapter overviewNext page

A window specified by a fixed number of rows; for example ROWS 10 PRECEDING specifies that only the latest 10 rows be included in the window. (The SQL standard calls this a "physical" window, and calls a Time-based Window a "logical" window.)

Be sure to see also the definition for Time-based Window.