Re: Highest values of a table

SELECT MAX(column) FROM table;

or

SELECT MIN(column) FROM table;

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Mark van Dijk <markvandijk_at_hotmail.com> wrote in message
news:f7niIWj1$GA.357_at_asd24-aux-005.tis.telfort.net...


> Hi,

>

> I hope someone can help me out. I have the following question:


> How can I select the say 20% highest (or lowest) values from a table by

 SQL


> or PL/SQL?


>

> Thanks,

>

> Mark

>

>