WHERE SN=“王华”)

D．SELECT SN，AGE，SEX FROM S

答案：A

WHERE AGE＞王华．AGE

9、检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是 。 A．SELECT S# FORM SC WHERE C#=“C2” AND GRAD＞＝

(SELECT GRADE FORM SC WHERE C#=“C2”) B．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE IN (SELECT GRADE FORM SC WHERE C#=“C2”)

答案：D

10、检索学生姓名及其所选修课程的课程号和成绩。正确的SELECT语句是 。 A．SELECT S．SN，SC．C#，SC．GRADE FROM S

WHERE S．S#=SC．S#

B．SELECT S．SN，SC．C#，SC．GRADE FROM SC

WHERE S．S#＝SC．GRADE 答案：C

11、检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩的降序排列出来。正确的SELECT语句是 。

A．SELECT S#，SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# ORDER BY 2 DESC

HAVING COUNT(*)＞＝4 WHERE C#=“C2” AND GRADE＞＝

(SELECT GRADE FORM SC WHERE C#=“C2”) B．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE IN 答案：D

二、填空题

1、SQL是 。 答案：结构化查询语言

(SELECT GRADE FORM SC WHERE C#=“C2”) C．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C#=“C2”) D．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE＞＝ALL (SELECT GRADE FORM SC WHERE C#=“C2”

C．SELECT S．SN，SC．C#，SC．GRADE FROM S，SC

WHERE S．S#=SC．S#

D．SELECT S．SN，SC．C#，SC．GRADE FROM S．SC C．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C#=“C2”) D．SELECT S# FORM SC

WHERE C#=“C2” AND GRADE＞＝ALL (SELECT GRADE FORM SC WHERE C#=“C2”)