关于时间的问题！

[tianluoniao]

表1
时间 工资 扣款 奖励
2003-01-03 1000 10 10
2003-02-03 1000 10 10
2003-03-03 1000 10 10
2003-04-03 1000 10 10
表2



怎么统计前三个月的工资和

[yujohny]

select SUM(工资) from 表1 where 时间 <'2003-04-01'

[cbzdream]

select SUM(工资) from 表1 where 时间 <'2003-04-01'

[minajo21]

select sum(工资) from 表1 where 时间>='2003-01-01' and 时间<='2003-03-31' group by 工资

[friendliu]

select sum(工资) from 表1 where month(时间)<'4'
go

[friendliu]

select sum(工资) from 表1 where month(时间)<'4' and year(时间)='2003'
go

[arrow_gx]

select sum(工资) as aaa, sum(扣款) as bbb,sum(奖励) as ccc from 表1 where 时间>='2003-01-01' and 时间<='2003-03-31'