09-08-2014 11:16 AM
I am trying to take the sum ofa numerical variable but getting the values in exponential. I must retain the sum as whole number as it is because i need it for comparing.
x = 9823748762398720570234;
create table temp as
select sum(x) from abc;
09-08-2014 11:57 AM
The precision of floating-point values is accurate to approximately 15 digits.
09-09-2014 05:25 AM
reading some old statistical books. make you data numbers to a converted offset position (1970's), sliders were seen, doing handwork understanding your data and tools.
The pitfall of working with big numbers is losing accuracy not notified.