select 日期,机器号,品种,班组号,产量=sum(产量) from 表 group by 日期,机器号,品种,班组号
哦 是只要求 产量求和啊 create trigger xxx on table_name for updata as select 日期,机器号,品种,班组号,产量=sum(产量) from table_name group by 日期,机器号,品种,班组号
create trigger xxx on table_name for updata as if exists(select * from sysobjects where id=object_id('表名') and xtype='U') drop table 表名 select 日期,机器号,品种,班组号,产量=sum(产量) Into 表名 from table_name group by 日期,机器号,品种,班组号
create trigger xxx
on table_name
for updata
as
select 日期,机器号,品种,班组号,产量=sum(产量) from table_name
group by 日期,机器号,品种,班组号
on table_name
for updata
as
if exists(select * from sysobjects where id=object_id('表名') and xtype='U')
drop table 表名
select 日期,机器号,品种,班组号,产量=sum(产量) Into 表名 from table_name
group by 日期,机器号,品种,班组号