SQL语句教程(01) SELECT SQL语句教程(02) DISTINCT SQL语句教程(03) WHERE SQL语句教程(04) AND OR SQL语句教程(05) IN SQL语句教程(06) BETWEEN SQL语句教程(07) LIKE SQL语句教程(08) ORDER BY SQL语句教程(09) 函数 SQL语句教程(10) COUNT SQL语句教程(11) Group By SQL语句教程(12) HAVING SQL语句教程(13) ALIAS SQL语句教程(
Student(S#,Sname,Sage,Ssex) 学生表 Course(C#,Cname,T#) 课程表 SC(S#,C#,score) 成绩表 Teacher(T#,Tname) 教师表 问题: 1、查询“001”课程比“002”课程成绩高的所有学生的学号; select a.S# from (select s#,score from SC where C#='001') a,(select s#,score from SC where C#='002') b where a.scor