The OVER() Clause

This video segment describes the OVER() clause, its various configurations in terms of how partitions and window frames are created and how data is sorted in the partition so that the window function can operate on the values. We will discuss partitions in great detail! The OVER() clause together with partitions and window frames is what gives power to the aggregate window functions. We will cover window frames and how they are defined in order to generate a set of partitions that contain the rows that are processed by the window functions. We will use several diagrams in order to illustrate the concepts and then several examples are shown to illustrate the various ways partitions and window frames work on real data sets using window functions. We will discuss ROWS and RANGE clauses and how they operate on data in the partition. These are used to define the smaller window frames in a partition.