MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » May 2006

Re: DB2 Question



fixed

Hi Joe,

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

Regards,
Paul 


----- 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.

Joe







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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact