Archives of the TeradataForum

Message Posted: Wed, 20 Jul 2011 @ 12:37:44 GMT

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

HI,

Hope this helps.

     select max(thedate),username
       from dbc.logonof
       where event='logon'
       group by username;

Not Tested

Thanks

Machha

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