ays_lks的博客

原创 嵌套查询练习

(1)查询计算机工程系女学生的学生学号、姓名及考试成绩。 SELECT student.sno,sname,degree FROM student,sc WHERE student.sno=sc.sno and sdept IN (SELECT sdept FROM student WHERE sdept="计算机工程系") AND ssex IN (SELECT ssex FROM student WHERE ssex="女"); ...