OBJECT_NAME OBJECT_TYPE OBJECT_ID GRP# R# RR# MOD# , r# - row_number() OVER (order by r#) AS tabibito# , DENSE_RANK() OVER (ORDER BY tabibito#) GRP# SELECT object_name, object_type, object_id If we add in Oracle ACE Aketi Jyuuzou's 'Tabibitosan' technique for grouping (which should be in everyone's repertoire), then the GRP# make the stratifications visible: Seven 'first' records, and then the final 5 of the results). (Notice that there are 8 sets of 5 records. Java/awt/TexturePaintContext JAVA CLASS 37643 29966 22473 1 Sqlj/translator/ClassPathEntry JAVA CLASS 22653 14982 37457 0 OBJECT_NAME OBJECT_TYPE OBJECT_ID R# RR# MOD# , row_number()over(order by object_id DESC)-1 AS rr# , TRUNC(MOD(row_number()over(order by object_id) , row_number()over(order by object_id)-1 AS r# Select object_name, object_type, object_id, r#, rr#, mod# Say you want to look at records from seven (roughly) equal-sized chunks.

Similarly, it's easy to get 'bite size' examples records from the entire ordering. However, few people can really grasp more than a dozen or so records.

, row_number()over(order by object_id DESC) rr# , row_number()over(order by object_id) r# Select object_name, object_type, object_id, r#, rr# If you only want the top and bottom records, then something like this: Assuming there's some order involved: If only the last 5000 records are interesting, just reverse the ordering.

Oracle sql developer tool