Archives of the TeradataForum
Message Posted: Fri, 25 Feb 2011 @ 13:55:46 GMT
I use TD SQL Assistant v13 and Nexus v5 to query TD. I have the same challenge in both, so I think it may be my SQL syntax
I am trying to create percentages. I have simplified my SQL to the following, for discussion purposes:
select cast( (3995852 * 100 / 12274677) as Decimal(6,3) ) as Data_Pct
The result I receive is 32. But the result that I expect is 32.554.
I have tried adding a FORMAT clause but that seems to not make a difference either. Suggestions?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|