Archives of the TeradataForum
Message Posted: Wed, 06 Jun 2001 @ 17:06:22 GMT
| 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.