Analytic Functions

Analytic functions perform computations on a window of rows defined by the over_clause. In contrast to GROUP BY, they compute the result for each row of the result set. The over_clause may contain a partition_clause, an order_clause, and a window_frame_clause.