Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Dec 2006 @ 12:54:04 GMT


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


Subj:   Re: GRAND TOTAL Not coming in the output screen
 
From:   McCall, Glenn David

          > Select * from   where date = '11/18/2004'
          >     and time= '13:31:46'

          > WITH COUNT(product_id) (TITLE 'GRAND TOTAL')
  I am expecting the GRAND TOTAL to be displayed in the bottom, whereas it does not come.  


I believe "With" only works in bteq.


Glenn Mc



     
  <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: 15 Jun 2023