• Thanks,

    This is what i need.

    How does rownum aggregates from 10 rows to 3 rows. can you explain.