填空题

SELECT命令中，表示条件表达式用WHERE子句，分组用 (8) 子句，排序用 (9) 子句。

【参考答案】

GROUP BY

<上一题目录下一题>

热门试题

单项选择题

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

A．SELECT S#,SUM(GRADE)FROM SC
WHERE GRADE＞=60
CROUP BY S#
ORDER BY 2 DESC
HAVING COUNT(*)＞=4
B．SELECT S#,SUM(GRADE)FROM SC
WHERE GRADE＞=60
GROUP BY S#
HAVING COUNT(*)＞=4
ORDER BY 2 DESC
C．SELECT S#,SUM(GRADE)FROM SC
WHERE GRADE＞=60
HAVING COUNT(*)＞=4
GROUP BY S#
ORDER BY 2 DESC
D．DELECT S#,SUM(GRADＥ)FROM SC
WHERE GRADE＞=60
ORDER BY 2 DESC
CROUP BY S#
HAVING COUNT(*)＞=4

单项选择题

检索学生姓名及其所选修课程的课程号和成绩，正确的SELECT语句是______。

A．SELECT S.SN,SC.C#,SC.GRADE
FROMS
WHERE S.S#=SC.S#
B．SELCECT S.SN,SC.C#,SC.GRADE
FROM SC
WHERE S.S#=SC.GRADE
C．SELECT S.SN,SC.C#,SC,GRADE
FROM S,SC
WHERE S.S#：SC.S#
D．SELSECT S.SN,SC.C#,SC.GRADE
FROM S,SC