1 2 Previous Next 16 Replies Latest reply: Mar 19, 2013 9:37 PM by Manik RSS

    How to select the third 1000 unique record?

    997641
      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