--------上机练习1------
select max(StudentResult),min(StudentResult) from result
where examdate=
(
select max(examdate)
from result where subjectid=
(
select subjectid
from subject where subjectname='oop'
)
)
and subjectid=
(
select subjectid
from subject where subjectname='oop'
)
----上机练习2------
select subjectname from subject
where gradeid in (select gradeid from grade where gradename='S1')
----上机3----
select studentname,studentno from student
where studentno not in(
select studentno from result
where subjectid=(
select subjectid from subject where subjectname='oop'
) and examdate=(
select max(examdate) from result
where subjectid=(select subjectid from subject where subjectname='oop')
)
)and gradeid=(select gradeid from grade where gradename='S1')
-----上机4-----
if exists (
select * from student
where gradeid=(select gradeid from grade where gradename='S1')
)
begin
update student set gradeid='2'
where gradeid='1'
end
S2 第一本书 第四章 上机练习1-4
最新推荐文章于 2022-07-24 20:30:30 发布