34,837
社区成员




2、查看所有姓张的员工数据
select id,name, team_id from Temployee where name like '张%'
3、查看每个团队的员工总数
select team_id,count(name) as namecount from Temployee group by team_id
4、查看每个员工所在团队的员工总数
select id,name,team_id,b.namecount from
(select id,name,team_id from Temployee )a
left join
(select team_id,count(name) as namecount from Temployee group by team_id)b
on a.team_id=b.team_id