首页 > 计算机类 > 等级考试 > 计算机三级 > 数据库 > 检索选修四门以上课程的学生总成绩(不统计不及格的课程 )，并要求按总成绩的降序捧列出来。正确的 SElECT 语句是

检索选修四门以上课程的学生总成绩(不统计不及格的课程 )，并要求按总成绩的降序捧列出来。正确的 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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

查看答案

正确答案： B
答案分析：无

包含此试题的试卷：

计算机等级考试三级数据库模拟试题

相关的试题

已知某班级 30 名学生数学考试成绩 (分) 如下： 40 45 50 52 54 55 61 64 64 66 69 71 71 72 74 75 76 78 78 79 81 85 85 86 86 87 88 91 95 96 要求： (1) 以 60 以下， 60.70，70 一 80，80.90，90 以上为分组区间编制组距分布数列; (2) 计算各组的组中值： (3) ...

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

基础教育阶段英语课程的任务是激发和培养学生，__使学生树立自信心，养成良好的学习习惯和形成有效的，__发展自主学习的能力和___精神，使学生掌握一定的英语基础知识和听说读写技能，形成一定的;___培养学生的观察、记忆、思维、___和创新精神 ; 帮助学生了解世界和中西方文化的差异，拓展视野，培养爱国主义精神，形成健康的人生观，为他们的和_____打下良好的基础。

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

已知基本表SC(S#,C#,GRADE),则“统计选修了课程的学生人次”的SQL语句为

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

给定资料： 1.2010年6月6日，《国家中长期人才发展规划纲要(2010-2020年)》由新华社受权全文播发。《人才规划》是我国第一个中长期人才发展规划，是当前和今后一个时期全国人才工作的指导性文件。制定并实施《人才规划》，是贯彻落实科学发展观、更好实施人才强国战略的重大举措，是在激烈的国际竞争中赢得主动的战略选择，对于加快我国经济发展方式转变、全面建设小康社会，具有重大意义。《人才规划...

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

1、产业结构调整包括产业结构合理化和高级化两个方面。产业结构合理化是指各产业之间相互协调，有较强的产业结构转换水平和良好的适合性，能适合市场需求变化，并带来效益的产业结构 ; 产业结构高级化，又称为产业结构升级，是指产业结构系统从较低级形式向较高级形式的转化过程。产业结构的高级化一般遵循产业结构演变规律，由低级到高级演进。产业结构调整是当今各国发展经济的重要课题，也是当前我国社会经济生活中一...

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

阅读以下关于软件系统建模的叙述，在答题纸上回答问题 1 至问题 3。【说明】某软件公司计划开发一套教学管理系统，用于为高校提供教学管理服务。该教学管理系统基本的需求包括： (1)系统用户必须成功登录到系统后才能使用系统的各项功能服务 ; (2) 管理员 ( Registrar) 使用该系统管理学校 (University)、系( Department)、...

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

虽然当下的大学自主招生考试受到的非议颇多，然而，走过十年路程的大学自主招生考试，大概还是要年复一年地继续考下去。毕竟，自主招生考试对于恢复大学人才选拔的功能，真正将符合自身育人理念的可造之才选拔到大学中来，还是着积极意义和明显功效的。复旦大学表示，占该校本科生30%的自主招生出者，他们在学业成绩、创新意识和创新能力等方面的表现大多数要比其他学生胜出一筹。大学自主招生考试能够继续考下去的因为它...

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

假定学生关系是S(S#，SNAME，SEX，AGE)，课程关系是 C(C#，CNAME，TEACHER)，学生选课关系是SC(S#，C#，GRADE)。要查找选修 "COMPUTER" 课程的 " 女" 学生姓名，将涉及到关系

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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

检索选修课程 "C2"的学生中成绩最高的学生的学号。正确的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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

检索学生姓名及其所选修课程的课程号和成绩。正确的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 HAVINC COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S# HAVING COUNT(*)＞=4

网站内容收集于网络，如有侵犯您的权益，请联系：gl@lm158.com，感谢您的支持
神奇助手题库网