需求描述
查找出选修了所有课程的学生
准备数据
1.表
学生信息表:student
课程信息表:course
学生选课表:studentcourse
2.脚本
create table STUDENT
(
stuno INTEGER not null,
sname VARCHAR2(20),
gender VARCHAR2(5),
age INTEGER
);
create table COURSE
(
couno INTEGER not null,
cname VARCHAR2(20)
);
create table STUDENTCOURSE
(
stuno INTEGER not null,
couno INTEGER not null
);
insert into student (STUNO, SNAME, GENDER, AGE) values (200215121, ‘李勇’, ‘男’, 20);
insert into student (STUNO, SNAME, GENDER, AGE) values (200215122, ‘刘晨’, ‘女’, 19);
insert into student (STUNO, SNAME, GENDER, AGE) values (200215123, ‘王敏’, ‘女’, 18);
insert into student (STUNO, SNAME, GENDER, AGE) values (200215124, ‘徐明’, ‘男’, 17);
insert into course (COUNO, CNAME) values (1, ‘数据库’);
insert i