Using rowid to retrieve records
631319May 18 2010 — edited May 19 2010I wonder if someone could tell me if it’s possible to do the following:
I would like to retrieve a collection of rowids such that each incremental rowid defines a certain number of records (200,000 in this example). Here’s how this might look:
Rowid(1)
Rowid(2)
Rowid(3)
…
Rowid(x)
Where: Select count(1) from table_a where rowid between rowid(1) and rowid(2)=200,000.
So, the question is – Is it possible to get the rowid for every 200,000th row in a large table?
I know, this seems pretty strange, and you no doubt wonder why I’m not using a user-defined key, but that’s impossible in this case.
Thanks for your help,
Tom