34,594
社区成员
发帖
与我相关
我的任务
分享
create table A(id int,days int)
create table B(id int,department varchar(50))
insert into A
select 1 , 2 union all
select 2 , 4 union all
select 3 , 6 union all
select 4 , 3 union all
select 5 , 1 union all
select 6 , 1
insert into B
select 1 , '办公室' union all
select 2 , '办公室' union all
select 3 , '客服' union all
select 4 , '客服' union all
select 5 , '开发' union all
select 6 , '开发'
select
B.department as '部门',
count(A.id) as '部门员工数',
min(A.days) as '该部门员工参加培训的最少天数'
from A,B
where
A.id=B.id
group by B.department
select b.员工所属部门 部门 , min(a.培训时间) 该部门员工参加培训的最少天数
from a,b
where a.员工号=b.员工号