测试: create table tool( type varchar(10))insert into tool select 'car' insert into tool select 'bus' insert into tool select 'moto' insert into tool select 'moto' insert into tool select 'bus' insert into tool select 'bus' select type ,count(type)as 总数 from tool group by type 得到预期结果bus 3 car 1 moto 2
create table tool(
type varchar(10))insert into tool select 'car'
insert into tool select 'bus'
insert into tool select 'moto'
insert into tool select 'moto'
insert into tool select 'bus'
insert into tool select 'bus'
select type ,count(type)as 总数 from tool group by type
得到预期结果bus 3
car 1
moto 2