Archives of the TeradataForum
Message Posted: Fri, 29 Jul 2005 @ 11:54:43 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|