摘要： 摘自：http://www.iteye.com/topic/194446设有学生选取修课程数据库：S（S#, SNAME, AGE, SEX, DEPARTMENT, ADDRESS, BIRTHPLACE）SC(S#, C#, GRADE)C(C#, CNAME, TEACHER)(1) 李老师所教的课程号、课程名称；1 SELECT C#, CNAME;2 FROM C;3 WHERE TEACHER=”李”(2) 年龄大于23岁的女学生的学号和姓名；1 SELECT S#, SNAME;2 FROM S;3 WHERE AGE>23 AND SEX=”女”(3) “李小波... 阅读全文

摘要： 摘自 http://www.iteye.com/topic/1112015现在有三个表student,score,course 对应的建表语句如下： View Code 1 CREATE TABLE student( 2 student_id NUMBER PRIMARY KEY, 3 student_name,VARCHAR2(30) NOT NULL) 4 5 CREATE TABLE score( 6 score_id NUMBER PRIMARY KEY, 7 student_id NUMBER, 8 course_id NUMBER, 9 score NUMBER)... 阅读全文

摘要： 1 SELECT T1.C#, 2 3 ROUND(T1.AVG_SCORE, 2) AVG_SCORE, 4 5 ROUND(T2.PASS_COUNT / T1.ALL_COUNT, 2) PASS_POINT 6 7 FROM (SELECT DISTINCT C#, 8 9 COUNT(1) OVER(PARTITION BY C# ORDER BY C#) ALL_COUNT,10 11 AVG(SCORE) OVER(PAR... 阅读全文