Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Nov 2010 @ 15:59:00 GMT


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


Subj:   Compare data in same column
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, November 5, 2010 09:57 -->

Hi

I need to check if 2 entries for a member are within 12 months of each other but not sure how to do this.

e.g.

     member_id       date_admitted
     311123          01/08/2009
     311123          0101/2010
     489900          08/09/2008
     489900          02/02/2010

output required

     member_id       two_in_12_months
     311123          yes
     489900          no

All help appreciated



     
  <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