Howto to force NULL rows at the bottom ?

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Howto to force NULL rows at the bottom ?
Date: 1999-12-03 13:57:25
Message-ID: 14407.52293.774116.312846@ampato.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

how can I force NULL rows at the bottom of the result list in an
ordered SELECT?

with ORDER BY I get

NULL
Peter
Jane

but I want

Peter
Jane
NULL

--
Dirk

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Lewis 1999-12-03 14:04:08 Re: [SQL] Another Date question
Previous Message Mitch Golden 1999-12-03 13:46:22 Re: pgsql-sql-digest V1 #431