Search for WINDOW ROWNUM in this forum - lots of exampes of how to use ROWNUM for windowing properly

- Chris