 |
 |
Archives of the TeradataForum
Message Posted: Tue, 07 Apr 2009 @ 21:08:47 GMT
Subj: | | Re: Sorting on Null Values |
|
From: | | Joseph D silva |
| I'm using Teradata. I'm trying to Order by Name but do not want the Null values to be at the top. Can anyone let me know the syntax for
This purpose? | |
There's probably another way ... but this is what I could quickly think off ...
Sel * form table1
order by case when L_name is null then 1 else 0 end,
L_name, case when F_name is null then 1 else 0 end, F_name;
Joseph D'silva
| |