數據庫的增刪改查(精)-文庫吧資料
2025-04-23 00:58本頁面
【正文】 group by snohaving avg(grade=80。*/create table Dept_ssex_count(Sdept char(15,Ssex char(2,Count1 smallintinsert into Dept_ssex_count(Sdept,Ssex , Count1select Sdept,Ssex,count(Sno from studentgroup by Sdept,Ssex。數據庫39。CS39。*/delete from Course where Cno not in(select o from SC select * from Course /* 刪除計算機系學生選修了數據庫課程的選課記錄。239。select * from SC /* 將選修了號課程且成績?yōu)榭盏倪x課記錄刪除。and Cno=(select Cno from Course where Cname=39。*/update SC set Grade=85where Sno=(select Sno from Student where Sname=39。CS39。239。select * from SC /* 將計算機系學習了號課程的學生成績置。*/update SC set grade=grade+5where Cno in (select Cno from SC where Cno=(select Cno from Course where Cname=39。數學39。數學39。2002152239。IS39。數據庫39。數據庫39。李勇39。%數據%39。select MIN(sagefrom student查詢課程名中包含“數據”的課程名。IS39
教學教案相關推薦
鄂ICP備17016276號-1