21,887
社区成员
发帖
与我相关
我的任务
分享
select count(*) pinpai, sum(cnt) as cnt
from (select pinpai, count(*) as cnt from car group by 1) T
pinpai cnt
4 6
你是一点数据库知识都不学?create temporary table car (pinpai varchar(10));
insert into car values ('Lambo'),('Audi'),('BMW'),('Audi'),('Toyota'),('Lambo');
select pinpai, count(*) as cnt from car group by 1
pinpai cnt
Audi 2
BMW 1
Lambo 2
Toyota 1