Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2014 @ 12:48:07 GMT

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

Hi Sandeep,

Try the following.

     SELECT USERNAME,MAX(logdate) AS last_logon_date
     FROM dbc.logonoffv
     GROUP BY 1
     HAVING last_logon_date < DATE-90;

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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