樓主的問題有點含糊,是要統計a字段值出現的次數還是a字段相同時b字段值的總和呢? --b的總和 select a,sum(b) as b from T1 group by a --a出現的次數 select a,sum(1) as b from T1 group by a
select a,sum(b)as b from t1 group by a
select a,sum(b) b from t1 group by a
select a,b from cc where a in (select a from cc group by a having (count(a) = 1)) union select a,cast(count(*) as varchar(20)) as numbers from cc group by a having (count(*) > 1)
--b的總和
select a,sum(b) as b from T1 group by a
--a出現的次數
select a,sum(1) as b from T1 group by a
union select a,cast(count(*) as varchar(20)) as numbers from cc group by a having (count(*) > 1)