Re: showing top x values in sql*plus

select column x from (
select columnx from table y order by columnx desc) where rownum<4

will do that

chrissysjunk_at_yahoo.co.uk (Chrissy) wrote in message news:<de060d08.0305261649.71155d69_at_posting.google.com>...
> hi all,
>
> does anyone know how to display the top 3 values of data retrieved
> from a table rather than all the values?
>
> thanks in advance
>
> chrissy
Received on Tue May 27 2003 - 08:09:41 CEST