Question

请教两问题，select into 和 group by-CSDN论坛

Answer 1

create table Teacher
(
DepartmentID int ,
TeacherID int ,
TeacherName varchar(100)
)

DELETE Department
insert into Department
select 1, 'AAA' union all
select 2,'BBB' union all
select 3, 'CCC'

insert into Teacher
select 1,101,'WACKY' UNION ALL
SELECT 1,102,'XIAOWANG' UNION ALL
SELECT 2,201,'WIXAOZHANG' UNION ALL
SELECT 3,301,'JACKY' UNION ALL
SELECT 3,302,'ANDY' UNION ALL
SELECT 3,303,'JAKY'

select DepartmentName 部门名,count(TeacherID) 教师数 into newtable
from Department d,Teacher t
where d.DepartmentID=t.DepartmentID
group by D.DepartmentName