Over Techniques

	Column Expression	Example
over	()	To use the entire dataset as one partition, see the middle subquery in From Subqueries.
	(partition column-name)	To group with a simple partition, see Group and Analyze Rows with Row Detail
	(partition column-name between rows n preceding and n following )	To apply a window to each row within a partition, see Partitions and Windows
	(partition column-name order by column-name)	To obtain running calculations in partitions, see Running Aggregates.
	(partition column-name order by column-name)	To provide an index of each row or ranking within each partition, see Number or Rank Rows.
	any-partition-expression	For examples of statistical analysis, see Analytic Functions for Partitions and Windows.