Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2012 @ 18:00:40 GMT


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


Subj:   Re: Error - 3504 :- Selected non-aggregate values must be part of the associated group.
 
From:   Geoffrey Rommel

Todd Walter wrote:

  Groups the constant values 1,2,3 not the positional columns in the select list. Teradata SQL does not support positional group by, the select list columns must be explicitly named.  


Uh ... I hesitate to disagree with Todd, but I've been using positional group by (successfully) for years. Has this changed in TD 13.10 or 14.0?



     
  <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: 23 Jun 2019