Archives of the TeradataForum

Message Posted: Mon, 01 Oct 2012 @ 20:14:15 GMT

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

     SEL username, MAX(logdate) AS last_login_date
       FROM dbc.logonoff
       GROUP BY 1 HAVING last_login_date < DATE -90

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