Oracle Analytic Function - First_Value, Last_Value
This is an example of Oracle analytic function
FIRST_VALUE OVER(ORDER/PARTTION BY ...) and
LAST_VALUE OVER(ORDER/PARTTION BY ...). The value
returned by FIRST_VALUE and LAST_VALUE is based on use
of ORDER BY or PARTITION BY as shown below. The data
has
NULL values
.
Result of above query using IGNORE NULLS
option:
Oracle registered trademark of Oracle Corporation.