SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select the third 1000 unique record?

User_28X4XMar 18 2013 — edited Mar 19 2013

I have an Accounts table with say 100K records. I selected the first unique 1000 by simply doing <=1000 and the second 1000 by doing not in(the first 1000). How can I select the third unique 1000 records whereby I dont have any of the first 2000? BTW ... I am using Toad on Windows. Any help highly appreciated. Thanks in advance - Dave.

Edited by: 994638 on Mar 18, 2013 6:45 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2013

Added on Mar 18 2013

#query, #sql

16 comments

1,252 views