Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Analytical Functions

 

Using the Window Functions

Window functions calculates things like cumulative sums, moving averages within a specified range of rows, a range of values, or an interval of time. Window function can work with: SUM(), AVG(), MAX(), MIN(), COUNT(), VARIANCE(), and STDDEV(). Window function can also work with FIRST_VALUE() and LAST_VALUE(), which return the first and last values in a window.