588
社区成员
发帖
与我相关
我的任务
分享
select pb_name as 姓名 , aa as 出勤天数, 白 as 早班,中 as 中班,夜 as 夜班
from (
select pb_name,pb_kqlx,count(*) sum_1 ,
(select count(*) from t11 b where pb_kqlx<>'休' and a.pb_name=b.pb_name) as aa
from t11 a group by pb_name,pb_kqlx
)t1
pivot(max(sum_1) for pb_kqlx in ([白],[休],[夜],[中])) as p