【文件属性】:
文件名称:Oracle练习题
文件大小:53KB
文件格式:DOCX
更新时间:2022-03-04 04:17:40
oracle
1、查询“001”课程比“002”课程成绩高的所有学生的学号
1. select a.S# from (select S#,score from SC where C#='001')a,
2. (select s#,score from SC where c#='002')b Where a.score>b.score and a.s# = b.s#;
3.
2、查询平均成绩大于60分的同学的学号和平均成绩
select S#, avg(score) from sc group by S# having avg(score)>60
3、查询所有同学的学号、姓名、选课数、总成绩
1. select student.S_id, student.Sname, count(sc.C_id), sum(score) from student
2. left join SC on student.S_id = SC.S_id group by Student.S_id, Sname