This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Mar 19, 2013 7:37 PM by Manik RSS

How to select the third 1000 unique record?

997641 Newbie
Currently Being Moderated
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
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points