Hi Joe,

Just a quibble... he probably meant 50 - 74 :-)


----- Oorspronkelijk bericht -----
Van: Joe Pluta [mailto:joepluta@xxxxxxxxxxxxxxxxx]
Verzonden: donderdag, mei 4, 2006 02:37 PM
Aan: ''Java Programming on and around the iSeries / AS400''
Onderwerp: RE: DB2 Question

> From: Paul Nicolay
> Hi,
> The problem is that DB2 doesn't support this, but it can be done by a
> trick which works by combining the following statements as one
> - Select the TOP 75 in descending order with cirteria
> - Select the TOP 25 of these in ascending order

Just a quibble... to get records 50-75, you'd have to specify the top 26,
not the top 25, on the second query.


Return to Archive home page | Return to MIDRANGE.COM home page