|
didnt help... the output was all the rows with product_weight in ascending order. I want only 5 rows rows with decending order of weight. Signature...................... e- mail at : santoshp@lot.tatasteel.com ITS, Tata Steel. Jamshedpur, India. Tel : 842134 (O) , 200279 (R). "Hall, Philip" <phall@spss.com> To: midrange-l@midrange.com Sent by: cc: midrange-l-admin@mi Subject: RE: top 5 heavy products drange.com 19/10/01 09:13 Please respond to midrange-l > My table v_product_data has 2 columns > product_id and product_weight.. > from STRSQL, i want to get 5 and only 5 top most heavy products. > How do i do it? Use the 'optimize' clause, i.e.; Select product_id, product_weight from v_product_data order by product_weight optimize for 5 --phil [ Deleted uuencoded file 'winmail.dat' ] _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
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.