SEO

#1 (**permalink**) 02-25-2008, 06:38 AM

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

#2 (**permalink**) 02-25-2008, 06:38 AM

On 28 Aug 2006 02:34:32 -0700, "Arno" <boulets@gmail.com> wrote:

>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

The SUM isn't rounded, that's just because of your display format.

--
Sybrand Bakker, Senior Oracle DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SUM precision