Re: order by date desc but NULLs last

On Mon, Feb 10, 2003 at 01:32:54PM -0500, Jean-Luc Lachance wrote:
> Why not try the obvious first?

Because it's not always obvious ;-) Yup, if you want two kinds of order
(NULLs last, descending dates), use two order by clauses. 
> order by gradedtime is null, gradedtime desc;
> 
> "Ross J. Reedstrom" wrote:

<a different, less elegant way to get the NULLs last>

Ross