Archives of the TeradataForum

Message Posted: Thu, 21 Jul 2011 @ 08:17:46 GMT

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

Hi,

You can also use below query to get the required results.

     sel username,event,max(logdate),max(logtime)
     from DBC .LogOnOff
     group by 1,2  having  event='logon'

Regards,

Kalyan Yadav.

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