First page Back Continue Last page Image

Using ROWS or RANGE to increase precision

CURRENT ROW

UNBOUNDED PRECEDING

UNBOUNDED FOLLOWING

expr PRECEDING

expr FOLLOWING

{ROWS | RANGE} {frame_start |

BETWEEN frame_start AND frame_end}

You can create Frames inside of Windows to further refine your output by using a ROWS or RANGE statement:

Value Options for frame_start or frame_end

RANGE treats duplicates in the target as one Object

ROWS treats duplicates in the target as different Objects