Thread: NULLS first ...
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:30 AM
Ralph
 
Posts: n/a
Default NULLS first ...

Hi

Is there a way to make NULLs appear first in this example:

SELECT login_time FROM my_table GROUP BY id ORDER BY login_time DESC

This gives me the list starting from most recent login and ending with
NULL values. Is there a way to make NULLs appear first keeping the times
data sorted like they are now.
Reply With Quote