how to limit rows

["Voris, John" <john.voris@xxxxxxxxxxxxx>]

Now I have a question.
For re-testing things, where we want see the most recent additions to a
file
( like the last 1000 records ), is there a shortcut SQL statement for
that ?
Would there be anything in SQL with FETCH , something like
FETCH LAST 1000 ROWS ONLY , or is that a pipedream ?


> message: 3
> date: Tue, 31 Jul 2012 20:41:48 +0000
> from: "Erhardt, Bill" 
> subject: RE: how to limit rows
>
> To select the 1st 1000 records of file a and place them in file b do
the following;
> Insert * into File_b
> Select * from File_a where rrn(File_a) <= 1000