Re: how to limit rows

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

I think you should be a plumber!

Couldn't resist - there's nothing that records the last records in SQL. 
The closest thing might be to have an identity column, then do a table 
expression to find it's largest value, then do a comparison that is 
something like IDENTCOL > max(IDENTCOL) - 1000

Even this might not be effective, although I'm not sure what would 
prevent it.

In PFs, RRNs are not reliable either, if RESUEDLT is in play.

Now where is that new flush valve?

HTH
Vern

On 7/31/2012 4:37 PM, Voris, John wrote:
> 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