|
|
Archives of the TeradataForum
Message Posted: Fri, 29 Jul 2005 @ 11:54:43 GMT
Subj: | | Re: NULLS LAST and NULLS FIRST |
|
From: | | Michael Larkins |
Aananth:
I have never seen anything like the first/last that you mention. As I read your question, using COALESCE was going to be my recommended
solution. Then, I see you have already discovered it. Since Teradata can sort on data that is not selected, this provides the functionality that
you are seeking to order your output.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |