文章目录
数据库使用子查询查询以下信息
1.查询所有学生的学号、姓名、课程号及成绩
SELECT o.stuno,stuname,s.cno,stuscore
FROM stuinfo o join stumarks s on o.stuno=s.stuno
join stucourse e on s.cno=e.cno;
2.查询选修“李斯文”老师课程的学生的学号及姓名勾
SELECT stuno,stuname
FROM stuinfo WHERE stuno=(SELECT cteacher FROM stucourse WHERE cteacher=“李斯文”);
3.查询没有选修课程时学生时基本信息(提示:左连接)
SELECT stuno,stuname,stusex
FROM stuinfo left join stucourse e on stuinfo.
4.查找同一课程成绩相同的选课记录(提示:子连接)
SELECT cno,cname
from stucourse WHERE stuscore
5.利用子查询查询选修了课程的学生的基本信息
SELECT DISTINCT stuinfo.stuno,stusex,stuname
FROM stuinfo join stumarks on stuinfo.stuno=stumarks.stuno
join stucourse on stumarks.cno=stucourse.cno
WHERE stuinfo.stuno in(SELECT stuno FROM stumarks);