select col1,sum(col2) as col2 from tb group by col1
select id,max(value)from tb group by id
select id,sum(value) as value from tb group by id
select id,max(value) from tb group by id
declare @t1 table( [id] varchar(20) , num int)insert into @t1 values('A', 5 ) insert into @t1 values('A', 6 ) insert into @t1 values('B', 4 ) insert into @t1 values('B', 8 ) insert into @t1 values('B', 7 ) select [id] ,sum( num ) as numfrom @t1 group by [id]
select id,max(value)from tb group by id
insert into @t1 values('A', 6 )
insert into @t1 values('B', 4 )
insert into @t1 values('B', 8 )
insert into @t1 values('B', 7 )
select [id]
,sum( num ) as numfrom @t1 group by [id]