Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2014 @ 11:18:46 GMT

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

Hi ,

Please use the below Query

     sel username , max(logondate)

     from dbc.LogOnOff
     having max(logondate)  < current_date-90

     group by  1;

Regards

Rohit Jain

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