Re: select rows 770000 until 770005 in a large table

Roland Schmidt <schmidtr_at_hager.de> wrote:

>
>I want to get the key.
>The reason is a problem during a Software upgrade (SAP).
>In our test system everything works well and in our production system the
>upgrade stopped with an error due to create the primary index after
>inserting 770005 rows.
>Now I try to find out why it works in one system and not in the other. I
>may help to get the key of row 770006, you know ?
>
>Roland

So what you want are the rows that were inserted 'last'? You MIGHT be able to use ROWID. If you are lucky the rowid will have 'incremented' for each row inserted and thus last row inserted will have the 'largest' rowid.

select rowid ID, TABLE.*, from TABLE order by ID DESC;

This would still return all the rows, but at least you could get them in reverse order of the insert.

John S. Fetzik
*REMOVE*jfetzik_at_sandc.com Received on Wed Feb 02 2000 - 17:05:49 CET