为什么累计求和时会自动变为整数

95518

有一数据表，类型如下
table1：
aa char(3),
jine decimal(14,2),
flag char(1)
想对其中的数据进行分类汇总，
select aa,sum(jine) ssje,0 qdje,0 pkje
from table1
where flag='2'
into temp tmpbd;

insert into tmpbd
select aa,0 ssje,sum(jine) qdje,0 pkje
from table1
where flag='1';

insert into tmpbd
select aa,0 ssje,0 qdje,sum(jine) pkje
from table1
where flag='3';

汇总
select aa,sum(ssje),sum(qdje),sum(pkje)
from tmpbd
group by 1

为什么合计出来了金额都是整理，没有小数呢？该如何做呢？多谢了

yunzhongyue

用sum(ssje)::dec试试！