First Last Value « Analytical Functions « Oracle PL / SQL

1.FIRST_VALUE and LAST_VALUE: which rows are used in the calculation of the window function for each row
2.first_value over partition
3.FIRST_VALUE() get the first rows in a window
4.LAST_VALUE(): get the last rows in a window
5.The query divides the current month’s sales amount by the previous month’s sales amount
6.last_value over range
7.last_value over range between
8.Avg over, first_value over
9.first_value over order by

10.first_value over order by range
11.first_value over order by rows