t2.teacher_id AS '教工号2', t2.teacher_name AS '教师姓名2' FROM teacher t1, teacher t2 WHERE t1.teacher_salary > t2.teacher_salary; 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 运行结果: 4 查询既学过“0001”又学过“0002”号课程的所有学生学号; SELECT sc1.student_id '学号' FROM ...
共有三个表 表1:curriculum 表2:grade 表3:student_info select distinct s.学号,s.姓名,g.课程编号,g.分数 from grade g inner join student_info s on s.学号=g.学号 where g.分数=(select MAX(分数) from grade where 学号=g.学号)
最后一行也是这个位置也是同样问题 GRADE.课程编号=CURRICULUM .课程编号 这个位置也是 select e.学号,e.姓名,f.课程编号,f.分数 from STUDENT e,(select c.学号 学号,c.分数 分数,d.课程编号 课程编号 from GRADE d,(select b.学号,MAX(a.分数)分数 from GRADE a,STUDENT b where a.学号=b....
group by st_id,st_name,c_no group by s.st_id,sc.st_name,sc.c_no这句