Re: SQL question in sqlplus!

From: Andreas Stephan <nospam.as.stedat_at_gmx.net>
Date: Mon, 13 Dec 1999 15:19:33 +0100
Message-ID: <38550075.773FB510@gmx.net>

select ..... order by fieldname asc|desc
select .... where rownum < 4

Have a look at the select syntax description and diagrams in the online documentation or books!

Andy

Zenith schrieb:

> I have learning sqlplus currently in a Oracle 7, sqlplus.
> how can I list out the records in ascending order of one field?
> if it can be done,
> and how can i just selected the first three rows? with the use of a
> function?
> or i can only do this by a very long sql statment?
Received on Mon Dec 13 1999 - 08:19:33 CST