Archives of the TeradataForum
Message Posted: Fri, 28 Feb 2003 @ 14:09:18 GMT
| Subj: || || Re: WINDDI, QUERYMAN and BTEQ generate different output for the same query |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, February 28, 2003 08:12 -->
| ||sum and count in Query man uses Decimal(18) where as sum and >count function in BTEQ utilizes FLOAT datatypes.|| |
Sorry, but this is mistaken. sum and count are done by the amps, so they're the same for everybody as long as you pass the same
sql. If the column that you are summing is float, the result will be float.