我有一个包含以下字段的MySQL(版本:5.7)表:
account: varchar
work_status: varchar
work_details: varchar有这样的数据:
account | work_status | work_details |
xxx@gmail.com work coding
xxx@gmail.com onBusiness conclude a contract 我想实现类似于以下内容的东西:
account | work_status_work | work_status_onBusiness |
xxx@gmail.com 22 8发布于 2019-10-30 15:35:15
您可以尝试使用条件聚合-
select account,
count(case when work_status='work' then 1 end) as work_status_work,
count(case when work_status='onBusiness' then 1 end) as work_status_onBusiness
from tablename
group by accounthttps://stackoverflow.com/questions/58620470
复制相似问题