分组求和？？？
表内容：
id business time
h001 200 2003-01-01
h001 280 2003-02-01
h002 300 2003-01-01
h002 180 2003-02-01
我想按id号把business求和形成一个字段，time是2003-02-01形成一个字段，id是一个字段？
问题点数：0、回复次数：5Top
1 楼fhuibo（永远深爱一个叫“莎”的好女孩儿）回复于 2003-11-04 09:09:28 得分 0
select id,sum(business),time from table group by idTop
2 楼kingting（Delphi2Java）回复于 2003-11-04 09:20:17 得分 0
select id,sum(business),time from table group by id, time with roolup
Top
3 楼shuixin13（犬犬（心帆））回复于 2003-11-04 10:08:50 得分 0
你的问题没有说清楚呀,
你应该是要各 ID 每天的 business 总和吧?????
select id,sum(business),time from table group by id, time
Top
4 楼txmjs（天地之间）回复于 2003-11-04 10:15:36 得分 0
select id ,sum(business) as sum ,time from yourtable group by idTop
5 楼LxbWater（Water）回复于 2003-11-04 10:46:30 得分 0
select id,sum(business),time from table group by id, timeTop
