--查询高二,二班所有学生姓名\性别\学好
Use School
select *from Student
select *from Class
select *from Student
where sClassId
(select clasId
from Class where cName='高二二班')
--查询高二二班和高二一班的所有学生,学生姓名\性别\学号
select *from Student
where sClassId in
(select clsId
from Class where cName='高二二班' or cName='高二一班')
--查询刘备,张飞,关羽的成绩
select*from Score
select *from sCore
where studentId in
(select sId from Student where sName='刘备'or sName='关羽'or sName='张飞')
Use School
select *from Student
select *from Class
select *from Student
where sClassId
(select clasId
from Class where cName='高二二班')
--查询高二二班和高二一班的所有学生,学生姓名\性别\学号
select *from Student
where sClassId in
(select clsId
from Class where cName='高二二班' or cName='高二一班')
--查询刘备,张飞,关羽的成绩
select*from Score
select *from sCore
where studentId in
(select sId from Student where sName='刘备'or sName='关羽'or sName='张飞')