select A.学号, A.姓名, B.课程名, C.分数 FROM 学生表 A, 课程表 B, 成绩表 C where A.学号=C.学号 and B.课程号=C.课程号
(2).
insert into 学生表(班级编号,学号,姓名,性别) values ('00001','00009','张三','男')
(3).
select A.课程号, A.课程名, sum(b.分数) 总成绩, avg(b.分数) 平均成绩, max(b.分数) 最高分
from 课程表 A, 成绩表 B
where A.课程号=B.课程号
group by A.课程号,A.课程名
having max(b.分数) >90
SELECT a.S# AS 学号, a.Sname AS 姓名, c.score AS 物理成绩FROM Student a, Course b, SC c
WHERE a.S# =c.S# AND b.C# =c.C# AND b.Cname ='物理'
① create table Student( Sno int not null PRIMARY KEY ,Sname string Unique, Ssex string ,Sage integer, Sdept string )
② SELECT SG.Sno, SG.Grade FROM SG WHERE (((SG.Cno)=2))
③ INSERT INTO sg(Sno,Cno,Cname,Grade)valves(“2012314”,”2”, “数据库管理”,90)
④ UPDATE SG SET SG.Grade = 95 WHERE (((SG.Sno)=2012314))
⑤ DELETE SG.Sno FROM SG WHERE (((SG.Sno)=2012314))
⑥CREATE VIEW VSG AS select * from SG
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)