Archives of the TeradataForum

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

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

<-- 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>>