Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 24 Sep 2002 @ 19:02:12 GMT


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


Subj:   Re: Count(case... to get a count(distinct acct_id) Is this possible?
 
From:   deWet, Johannes M

Bruce,

I suspect the problem is not your count(distinct) SQL, it's the additional columns you're selecting after your count(distinct ....). Try your count(distinct case..) on it's own (the way you have it coded should work). If you need to do something like SELECT count(distinct columna),count(distinct columnb), I would suggest doing a subselect with a union etc.., or something similar...



     
  <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: 28 Jun 2020