Re: select x max values

Try This:

Select Prices from
(
SELECT prices
  FROM table_prices
 ORDER BY prices DESC
)
Where Rownum <= x;

"Miran" <aa_at_somone.si> wrote in message
news:iR5p5.678$jL4.3596_at_news.siol.net...
> My problem:
> I vant to select x max values from a table .
> For example
> My table is prices and it's values ar 10,11,12,13,14,15
> I want to select 3 max values form this table, and I dont want it to be
> any function or procedure just select. I have a solution but it's preate
> slow, so if you have any idea ...
>
> miran
>
>
Received on Thu Aug 24 2000 - 08:49:44 CDT