when you ORDER a set of records in analytic functions you can specify a window of rows to consider,ignoring the others.
You can do this using the ROWS clause
UNBOUNDED PRECEDING
The window starts at the first row of the partition.
UNBOUNDED FOLLOWING
The window ends at the last row of the partition.
CURRENT ROW
window begins at the current row or ends at the current row
n PRECEDING or n FOLLOWING
The window starts or ends n rows before or after the current row
Follow the link for more details - https://community.oracle.com/thread/1020352?tstart=0
No comments:
Post a Comment