RE: top 5 heavy products

["Hall, Philip" <phall@xxxxxxxx>]

oops, that of course doesn't really do it correctly, you'll need to use the
FETCH clause

Select product_id, product_weight
from v_product_data
order by product_weight
fetch first 5 rows only

-----Original Message-----
From: Hall, Philip
Sent: Thu 10/18/2001 10:43 PM
To: midrange-l@midrange.com
Cc:
Subject: RE: top 5 heavy products



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