Re: SQL question in sqlplus!

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Mon, 13 Dec 1999 14:57:43 +0100
Message-ID: <832u1l$3g0$1@news.inet.tele.dk>

select a, b, c from your_table
where rownum < 4
order by b;

hth,
Ivan Bajon, ocp

Zenith <jackyleo_at_attmysite.com> wrote in message news:830rsb$jae$1_at_m5.att.net.hk...
> 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 - 07:57:43 CST