Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2014 @ 10:18:42 GMT

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

Hi,

Is there any way to figure out the names who not logged since > 3 months. Need help to move out of error below,

     select username from dbc.logonoff where (select date - logdate from dbc.logonoff  )>90;

     *** Failure 3669 More than one value was returned by a subquery.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

     BTEQ -- Enter your SQL request or BTEQ command:

Thanks in advance.

Regards,

Sandeep.

GANGA SANDEEP KUMAR
GTS-Technical Support Specialist

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