create table t(
id int identity(1,1),
icount int,
pid varchar(1),
item varchar(1),
zt varchar(1)
)
insert t
select 2,'0','A','B' union all
select 3,'0','A','B' union all
select 3,'0','E','F'
select sum(icount)as icount,pid,item,zt from t group by pid,item,zt
--result:
icount pid item zt
------------------------------
5 0 A B
3 0 E F
create table t(
id int identity(1,1),
icount int,
pid varchar(1),
item varchar(1),
zt varchar(1)
)
insert t
select 2,'0','A','B' union all
select 3,'0','A','B' union all
select 3,'0','E','F'
select sum(icount)as icount from t group by pid,item,zt
--result:
icount
-------
5
3