Re: Finding the 10 smallest values in a column
From: Jeff Brown <JF_Brown_at_pnl.gov>
Date: 1997/11/12
Message-ID: <64dej1$nr71_at_bbs2.pnl.gov>#1/1
Date: 1997/11/12
Message-ID: <64dej1$nr71_at_bbs2.pnl.gov>#1/1
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 CET