如何把选择出来的一列值相加呢？？？

Question

set @a=sum(f_amount) 这句f_amount也该是个变量

Answer 1

select @a=sum(f_amount) from ......

Answer 2

select @a=sum(f_amount)from a_samplestepticket1 where f_retive1=@f_retive and(f_date1>=@f_begindate and f_date1<=@f_enddate)and
(f_tofactory=0)

Answer 3

試一試﹕
set @a=(select sum(f_amount)from a_samplestepticket1 where 
f_retive1=@f_retive and(f_date1>=@f_begindate and f_date1<=@f_enddate)and
(f_tofactory=0))

Answer 4

select @a=sum(f_amount)
from a_samplestepticket1 where 
f_retive1=@f_retive and(f_date1>=@f_begindate and f_date1<=@f_enddate)and
(f_tofactory=0)这样就可以了