Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Jun 2001 @ 17:06:22 GMT

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

Subj:   Re: Query conundrum
From:   John K. Wight

Try derived tables in your query to pick up the different distinct counts or values in the final result.

Oh, this is not necessarily a Teradata restriction but rather extensions to Oracle SQL. Informix has the same thing but experience with Informix showed me that you could run the same query multiple times on the exact same large data set and you might get different answers - if it ever came back at all! Not THAT was cool! Not an SQL extension I would like to have in my DBMS.

  <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: 28 Jun 2020