OVER « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. OVER
16.20.OVER
16.20.1.AVG(salary) OVER
16.20.2.ROUND(AVG(salary) OVER())
16.20.3.Use partitioning in the OVER clause of the aggregate-analytical function
16.20.4.Ratio-to-Report
16.20.5.Using Analytic Functions AVG(Mark) OVER (PARTITION BY StudentID ORDER BY StudentID, Mark)
16.20.6.Using Analytic Functions: AVG(Mark) OVER
16.20.7.Using Analytic Functions: AVG(Mark) OVER (ORDER BY StudentID, Mark)
16.20.8.Using Analytic Functions: AVG(Mark) OVER(PARTITION BY StudentID ORDER BY StudentID, Mark RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
16.20.9.sum over (nothing)








16.20.10.sum over partition by, order by
16.20.11.sum salary over PARTITION BY