Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 24 Sep 2001 @ 20:11:25 GMT


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


Subj:   Query help needed for clown table
 
From:   John Smith

What is wrong with this query?

Sel avg(product_cost) from online_entry.clown_supplies
where product_name like '%big shoes%'
and product_cost > $50;

My error is 3822: cannot relove column $50.



     
  <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