28,408
社区成员




select a.*, b.c1, c.c2
from gongzimingxi a
left join (select 姓名, count(1) c1 from gongzimingxi group by 姓名) b
on a.姓名 = b.姓名
left join (select 姓名, liushuihao, count(1) c2
from gongzimingxi
group by 姓名, liushuihao) c
on a.姓名 = c.姓名
and a.liushuihao = c.liushuihao
order by a.姓名, a.liushuihao
select a.*, b.c1, c.c2
from gongzimingxi a
left join (select user_name, count(1) c1 from gongzimingxi group by 姓名) b
on a.user_name = b.user_name
left join (select user_name, liushuihao, count(1) c2
from gongzimingxi
group by 姓名, liushuihao) c
on a.user_name = c.user_name
and a.liushuihao = c.liushuihao
order by a.姓名, a.liushuihao
select 姓名, liushuihao, 工位, 实际工时, 增加系数倍率, 日总产量, 小时产能, 运行时间
from 表
group by 姓名, 共位
order by liushuihao
select 姓名, liushuihao, 工位, 实际工时, 增加系数倍率, 日总产量, 小时产能, 运行时间
from 表
group by 姓名
order by liushuihao
select 姓名, liushuihao, 工位, 实际工时, 增加系数倍率, 日总产量, 小时产能, 运行时间
from 表
group by 姓名