在sql数据库中有一表,有字段consumNum(数据类型:char),consumType(数据类型:char),consumMoney(数据类型:decimal),consumTime(数据类型:datetime).
   问题是怎么可以将consumMoney 下的数据根据consumType ,consumTime分组求和?举例如下:
        
                 consumNum          consumType          consumMoney       consumTime
                    001                儿童摄影           23               2010/1/1
                    002                儿童摄影           23               2010/1/2
                    003                婚纱摄影           500              2010/1/3
                    004                儿童摄影           23               2010/1/4

根据consumType,consumTime的月份分组计算出consumMoney的总和可以存在decimal类型的变量total中,如上所举例子,在一月份儿童摄影total=69.

Select consumType sum(consumMoney) from table group by consumType

如何是C#2008以上的版本的话，那你可以试试用LINQ来查询，

select sum(consumMoney) from tempTable where consumTime between '2010-01-1' and '2010-01-31'  group by consumType
最好是加个时间的条件.
如不加条件,按你所说的按consumType和consumTime分组的话,那么我个人觉的还要对consumTime这字段进行处理

select consumType,sum(consumMoney) 总和,datepart(mm,consumTime) 月份 from tempTable
     group by consumType,datepart(mm,consumTime)

create table tempTable
(
    id int not null primary key identity(1,1),
    consumNum char(10) not null,
    consumType char(20) not null,
    consumMoney decimal not null,
    consumTime datetime not null
)
insert into tempTable(consumNum,consumType,consumMoney,consumTime)
    values('001','儿童摄影',23,'2010/1/1')
insert into tempTable(consumNum,consumType,consumMoney,consumTime)
    values('002','儿童摄影',23,'2010/1/2')
insert into tempTable(consumNum,consumType,consumMoney,consumTime)
    values('003','婚纱摄影',500,'2010/1/3')
insert into tempTable(consumNum,consumType,consumMoney,consumTime)
    values('004','儿童摄影',23,'2010/1/4')
insert into tempTable(consumNum,consumType,consumMoney,consumTime)
    values('005','儿童摄影',23,'2010/2/4')
select consumType,sum(consumMoney) 总和,datepart(mm,consumTime) 月份 from tempTable
     group by consumType,datepart(mm,consumTime)


select consumType,sum(consumMoney)总和 from tempTable where consumTime between '2010-01-01' and '2010-01-31 '  group by consumType

楼上的很好。
我们假设原来的表名为Fm，要写入统计数据的表名为fm;在窗体里建两个datatimepicker、一个button和一个datagridview。
string sqlstr="Data Source=(local);Initial Catalog=Fm;Persist Security Info=True;User ID=sa;Password=";
SqlConnection con = new SqlConnection(sqlstr);
con.Open();
string comstr =" select consumType,sum(consumMoney) 总和,datepart(mm,consumTime)月份 into fm from Fm where consumTime between '"+"dateTimePicker1.Value"
+"' and '"+"dateTimePicker1.Value"+"'";
SqlCommand com = new SqlCommand(comstr, con);
com = new SqlCommand(comstr,con);
com.ExecuteNonQuery();
con.Close();
我也是新手，只是自己的思路，可能sql语句写的不准确。还请见谅！


[ 本帖最后由 名沁 于 2010-6-2 22:20 编辑 ]