Re: Finding the 10 smallest values in a column

How about (I didn't test this, but I've used similar):

Select VAL
  From TABLE
 Where ROWNUM < 11
 Order by VAL Asc
;

If you want values only once, make that "Select Distinct VAL".

Jeff Brown
JF.Brown_at_pnl.gov

In article <01bcefae$f24b4b60$108624c3_at_default>, ogranach_at_club-internet.fr says...
>
>
>Is there an easy way of finding and inserting into another table the 10
>smallest of a column in a table?
>
> Thanks for your help.
>
Received on Wed Nov 12 1997 - 00:00:00 CST