Re: showing top x values in sql*plus

>>>>> "Chrissy" == Chrissy <chrissysjunk_at_yahoo.co.uk> writes:

 Chrissy> hi all, does anyone know how to display the top 3 values of  Chrissy> data retrieved from a table rather than all the values?

SELECT *
FROM ( select <whatever> from <your table> where <whatever> ) WHERE rownum < 4;

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!