大神救命啊
答案:2 悬赏:0 手机版
解决时间 2021-11-23 14:44
- 提问者网友：听门外雪花风
- 2021-11-23 07:40
大神救命啊
最佳答案
- 五星知识达人网友：玩家
- 2021-11-23 09:02
1. select s.Sname,c.Cname,sc.Grade
from Sc left outer join Student s on sc.Sno=s.Sno
left outer join Course c on sc.Cno=c.Cno
2. select s.Sno,s.Sname,c.Cname,sc.Grade
from Student s left outer join Sc on sc.Sno=s.Sno
left outer join Course c on sc.Cno=c.Cno
3. select Sname, Sage from student where sage< (select max(sage) from student where Sdept = '信息学院') and Sdept <> '信息学院'
4. select sname from student
where not exists ( select * from course where not exists (select * from sc where sno =student.sno and cno=course.cno))
5. select Sdept,count(*) as 人数
from student group by Sdept
from Sc left outer join Student s on sc.Sno=s.Sno
left outer join Course c on sc.Cno=c.Cno
2. select s.Sno,s.Sname,c.Cname,sc.Grade
from Student s left outer join Sc on sc.Sno=s.Sno
left outer join Course c on sc.Cno=c.Cno
3. select Sname, Sage from student where sage< (select max(sage) from student where Sdept = '信息学院') and Sdept <> '信息学院'
4. select sname from student
where not exists ( select * from course where not exists (select * from sc where sno =student.sno and cno=course.cno))
5. select Sdept,count(*) as 人数
from student group by Sdept
全部回答
- 1楼网友：末日狂欢
- 2021-11-23 09:35
这么简单的sql 至于直呼救命吗。。。
哪个不会吱
哪个不会吱
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯