
------解决方案--------------------
select kaihusj,name,count(*) counts from table group by kaihusj,name
------解决方案--------------------
select kaihusj,Leixingid,count(1) counts from table group by kaihusj,Leixingid

select kaihusj,Leixingid,count(1) counts from table group by kaihusj,Leixingid