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