Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2012 @ 14:05:09 GMT

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

Perhaps something like this would work for your

     select login_Id, login_dt
     from your_table
     qualify row_number() over (partition by login_ID order by login_dt asc ) = 2 ;

Paul Burns

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