Skip to content

Glossary: SQL Beyond the Basics

OVER

Also written: OVER ()

The clause that turns an aggregate or ranking function into a window function. Inside it you put PARTITION BY, ORDER BY and an optional frame.

Where the book teaches it

Related terms

Window functionPartitionFrame