Demonstrates use of LEAD and LAG functions to get next and previous data.

Demonstrates ordering data within each group and concatenate the values in a comma delimited list.

Demonstrates how to rank the records based on a column value or expression.

Demonstrates how to compare the current value against the sum of another set of values.

Demonstrates how to assign a serial number to a partition of records. This is very useful in reporting, especially in places where different partitions have their own serial numbers.

Top-N queries provide a method for limiting the number of rows returned from ordered sets of data.