Re: sql: results returned in order
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 10 Oct 2001 05:19:07 -0700
Message-ID: <a20d28ee.0110100419.3aa3c9dc_at_posting.google.com>
Date: 10 Oct 2001 05:19:07 -0700
Message-ID: <a20d28ee.0110100419.3aa3c9dc_at_posting.google.com>
Rob Hazlewood <rob_at_moofed.com> wrote in message news:<3bc3cff9$0$580$afc38c87_at_news.optusnet.com.au>...
> Hi,
> I have a small section of a program that lists the users that are using a
> java servlet, which is using oracle 8i with the thin client driver
>
> I have been using the following command:
> SELECT id,name FROM users
> and then arranging into order locally (decending id number).
>
> is there a way to get the resultset to retreive results in arranged order?
>
> thanks
> Rob
Just use
select id, name from users order by id
and start to *learn* sql *now*.
Regards,
Sybrand Bakker
Senior Oracle DBA
Received on Wed Oct 10 2001 - 14:19:07 CEST