create table [User]
(
id int,
[name] varchar(10),
deptid int
)
create table dept
(
id int,
[name] varchar(10)
)
insert into [user] select 1,'user1',1
union select 2,'user2',1
union select 3,'user3',1
union select 4,'user4',2
union select 5,'user5',2
insert into dept select 1,'dept1'
union select 2,'dept2'
select count([user].id),dept.[name]
from [User]
inner join dept on [user].deptid = dept.id
group by dept.id,dept.[name]
温馨提示:答案为网友推荐,仅供参考