Archives of the TeradataForum
Message Posted: Mon, 06 Jan 2003 @ 09:05:41 GMT
The following is the query which gives me the error message in the subject. If I cast anyone of these as dec(15,1) I am losing data accuracy. There are 200 thousand rows in my table.
Can anybody suggest a work around to get the accurate result?
select l_abcd, l_efgh, sum(cast(l_ijkl as decimal(15,2)) * (1 - cast(l_mnop as decimal (15,2))) * (1 + cast(l_qrst as decimal(15,2)))) as sum_ofcol, from TABLE01 where l_uvwx <= date '1996-10-11' - interval '45' day group by l_abcd, l_efgh order by l_abcd, l_efgh;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|