Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Jul 2005 @ 11:54:43 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023