Archives of the TeradataForum

Message Posted: Wed, 31 Dec 2003 @ 16:57:02 GMT

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

For the last mebership date for each customer -

     select  *
              from MEMBERSHIPS
           group by  CUST_ID
     qualify rank(MEMBERSHIP_DATE DESC) = 1

For the first mebership date for each customer -

     select  *
         from MEMBERSHIPS
           group by  CUST_ID
     qualify rank(MEMBERSHIP_DATE ASC) = 1

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