SQL code:
create table student (sid varchar(10),sname varchar(10),sage varchar(10),ssex varchar(10))
create table Sc (sid varchar(10),cid varchar(10),score int)
insert into sc select '0001','001',80
insert into sc select '0001','001',90
insert into sc select '0001','002',70
insert into sc select '0001','003',85
insert into sc select '0002','001',50
insert into sc select '0003','001',60
insert into sc select '0003','002',70
insert into sc select '0004','001',60
insert into sc select '0004','002',70
insert into sc select '0004','003',80
insert into sc select '0004','004',90
insert into student select '0001','swichin','26','男'
insert into student select '0002','lamh','27','男'
insert into student select '0003','ballack','34','男'
insert into student select '0004','lucio','32','男'
查询与某学生学的一样或者更多的课程的学生
比如学生0001学习了 001,002,003课程
那么符合条件的学生只有0004这一个了
select sname from student where 课程ID(不知道哪个代表课程)= 001or课程ID=002or课程ID=003 应该是这样,呵呵 不太确定 你试一下吧~~~
对了 那个sc表不符合范式, 加一个学期列吧
这样 sid,class,学期 三个列作为联合主键
SQL code:
--> 生成测试数据表: [tb]
IF OBJECT_ID('[student]') IS NOT