Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
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 Kind regards, Paul ----- Oorspronkelijk bericht ----- Van: Muhammad Owais [mailto:muhammadowaisbilal@xxxxxxxxx] Verzonden: donderdag, mei 4, 2006 10:26 AM Aan: java101@xxxxxxxxxxxx, java400-l@xxxxxxxxxxxx Onderwerp: DB2 Question Hello; Can anybody help me in writing a simple query to get data ranging from record # 50 to record # 75 in the query below: SELECT * FROM DB2ADMIN.ST_ITEM Thanking you in an advance With Regards Muhammad Owais Bilal Awan With regards Allah Hafiz Muhammad Owais Bilal Awan, +923002171163 --------------------------------- Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
