RE: sql query

add NULLS FIRST after the ORDER BY CAR_MAKE:

select

  to_number(null) as id,

  to_char(null) as car_make

from

  dual

union

select

  id,

  car_make

from

  carmake

order by

  car_make NULLS LAST;

Tony Aponte

-----Original Message-----

From: Steven Hovington [mailto:steven.hovington_at_procession.com]

Sent: Tuesday, December 11, 2001 10:45 AM

To: Multiple recipients of list ORACLE-L

Subject: sql query

Hi,

I have this sql statement:

select

  to_number(null) as id,

  to_char(null) as car_make

from

  dual

union

select

  id,

  car_make

from

  carmake

order by

  car_make;

So this selects a blank record and then the records from carmake.  But I

want the blank record to

appear at the top of the list, and it must be done in the select statement.

Can this be done?

TIA, Thanks,

Steven Hovington

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: Steven Hovington



  INET: steven.hovington_at_procession.com



Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).