Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2004 @ 10:30:36 GMT


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


Subj:   Re: Null values in queries
 
From:   Narayan Murthy

Yes, If you see the explain of your query , you will find the elimination of NULL. The behaviour is correct, 'cause you asked for a fieldval !='P' which means you have asked to retrieve rows which do not contain the value 'P', so all the knowns are returned and the unknowns(Null) eliminated. The blank is considered 'cause it again is a known it is something which can be defined.


Narayan



     
  <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: 27 Dec 2016