From: | "A(dot)M(dot)" <agentm(at)cmu(dot)edu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | order by date desc but NULLs last |
Date: | 2003-02-09 22:29:29 |
Message-ID: | F427C52A-3C7D-11D7-A094-0030657192DA@cmu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I have a simple query that sorts by descending date but the NULL dates
show up first. Is there a way I can sort so they come last without
sorting ascending?
SELECT submittime,score,gradedtime FROM student_gradedmaterial WHERE
gradedmaterialid=3 and studentid=102 order by gradedtime desc;
submittime | score | gradedtime
---------------------+-------+----------------------------
2003-01-30 22:56:38 | |
2003-01-31 03:42:29 | 99 | 2003-02-06 14:21:43.043587
but what I want is all the graded items first in gradedtime desc and
NULL afterwards. I do need to keep the NULL score rows. (So I get the
latest submitted grade for the assignment but also any ungraded
submission information.)
Thanks for any advice.
><><><><><><><><><
AgentM
agentm(at)cmu(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2003-02-09 22:56:15 | Re: referencing column names properly |
Previous Message | Sill-II, Stephen | 2003-02-09 14:18:05 | Re: referencing column names properly |