Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2012 @ 20:39:54 GMT


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


Subj:   HELP: SELECT failed. 3706: Syntax error
 
From:   JAMES PARK

TD13 Windows XP

I ran below SQL and it fails with this error, "SELECT failed. 3706: Syntax error: expected something between an integer and the 'select' keyword." I wonder what to change. Thank you,

     SELECT top 255 select  Value, count(*)
      from ( select Value from ABC.def sample 500000 )  as group by 1 order by 2 desc;


     
  <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