Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Find users not logged since > 3 months
From:   Ganga, Sandeep Kumar


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.



GTS-Technical Support Specialist

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016