Thread: SUM precision
View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 07:38 AM
Arno
 
Posts: n/a
Default SUM precision

Hello,

I have a little problem with the fonction sum. I use this query :
select SAL_ID, sum(LIG_MONT1) AS MNT from LIGNE group by SAL_ID.

In my table LIGNE, LIG_MONT1 is a number with 5 decimal digits. But
when I execute the query, the sum is rounded with 0 decimal digit.
Somebody know this problem ? Do you have a solution for me ?

Tks in advance.

Arno

Reply With Quote