Over « Analytical Functions « Oracle PL / SQL

1.

Include a final ordering of the result set with an ORDER BY at the end of the query

2.

sum over (nothing)

3.

sum over partition by, order by

4.

Get Products: RANK() OVER in subquery

5.

Lag salary over, lead salary over

6.

Using Analytic Functions AVG(Mark) OVER (PARTITION BY StudentID ORDER BY StudentID, Mark)

7.

Using Analytic Functions: AVG(Mark) OVER

8.

Using Analytic Functions: AVG(Mark) OVER (ORDER BY StudentID, Mark)

9.

Using Analytic Functions: AVG(Mark) OVER(PARTITION BY StudentID ORDER BY StudentID, Mark RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

10.

Using Analytic Functions: AVG(Mark) OVER(PARTITION BY StudentID ORDER BY StudentID, Mark ROWS 1 preceding

11.

Use over partition in subquery