Re: showing top x values in sql*plus
From: Maximus <qweqwe_at_qwqwewq.com>
Date: Tue, 27 May 2003 03:09:24 GMT
Message-ID: <EFAAa.72713$3C2.2305022_at_news3.calgary.shaw.ca>
Date: Tue, 27 May 2003 03:09:24 GMT
Message-ID: <EFAAa.72713$3C2.2305022_at_news3.calgary.shaw.ca>
Use the pseudocolumn ROWNUM, simply add a where clause like WHERE ROWNUM<=3
"Chrissy" <chrissysjunk_at_yahoo.co.uk> 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 - 05:09:24 CEST