Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016