Re: how to select NULL first

From: Christoph Pfrommer <Christoph.Pfrommer_at_oracle.com>
Date: Thu, 10 May 2001 08:45:06 +0200
Message-ID: <3AFA38F2.6010409@oracle.com>

Edward Rusu wrote:

>Hi All,
>
>Let's assume that we have a table A, columns c1, c2,.. with index c1. If you
>run a select:
>
>select * from A order by c1;
>
>rows with NULL value of c1 will be listed at the end. Is it possible to
>configure Oracle to have NULLs listed first?
>

Hi Edward,

select * from A order by c1 NULLS FIRST;

I can't tell by heart for how long this command is in Oracle SQL but it exists and is working in Oracle8i (8.1.7). Regards, Christoph. Received on Thu May 10 2001 - 01:45:06 CDT