Archives of the TeradataForum
Message Posted: Wed, 10 Sep 2014 @ 10:18:42 GMT
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.
GANGA SANDEEP KUMAR
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|