× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2001

getting top 5 most heavy products

the fol query works on any database but when i ran it on my production
machine on a table with 50000 rows, the DB unti was 99 % and CPU was 88 %
So plz dont try it  on large tables..



 select id_product, mass  from v_pprdslab t1
 where 5 > (select  count(id_product)  from
                            v_pprdslab t2
             where t1.id_product < t2.id_product)
              order by mass desc



i think i will have to wait till we get v5r1 and can use fetch clause..
till then have to use a program only..
okay
santosh.


Signature......................

e- mail at :  santoshp@lot.tatasteel.com
ITS, Tata Steel.
Jamshedpur, India.
Tel : 842134 (O) , 200279 (R).

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.