题目内容

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

A. SELECT S#，SUM(GRADE) FROM SC
B. WHERE GRADE>=60
CROUP BY S#
D. ORDER BY 2 DESC
E. HAVING COUNT() >=4
F. SELECT S#，SUM(GRADE) FROM SC
G. WHERE GRADE>=60
H. GROUP BY S#
I. HAVING COUNT() >=4
J. ORDER BY 2 DESC
K. SELECT S#，SUM(GRADE) FROM SC
L. WHERE GRADE>=60
M. HAVINC COUNT() >=4
N. GROUP BY S#
ORDER BY 2 DESC
P. DELECT S#，SUM(GRADE) FROM SC
Q. WHERE GRADE>=60
R. ORDER BY 2 DESC
S. CROUP BY S#
T. HAVINC COUNT() >=4

查看答案

搜索结果不匹配？点我反馈

更多问题

Not until you promise not to be tardy again ______ consider transferring you to the newly established branch office.

A. (A) I will
B. (B) will l
C. (C) I am
D. (D) am I

计算机的声音输出设备

A. 系统总线
B. 控制器
C. 运算器
D. 声卡
E. 调制解调器

The labor market has been tight over the past two years, so we can expect some request for salary ______ from our senior employees.

A. (A) raises
B. (B) rises
C. (C) arises
D. (D) arouses

Mr. Wilson finds ______ useful to hold a staff meeting twice a week because it helps improve the efficiency of the company.

A. (A) that
B. (B) those
C. (C) these
D. (D) it