Archives of the TeradataForum

Message Posted: Tue, 21 Apr 2009 @ 09:27:48 GMT

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

     select LoanID,tran.Amount tran_amount
     from loan
     inner join tran
     on loan.LoanID = tran.LoanID
     and Tran.Type = 'D'
     QUALIFY ROW_NUMBER() OVER (PARTITION BY LoanID ORDER BY tran.PostDate DESC  ) = 1

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