皮皮学，免费搜题
登录
logo - 刷刷题
搜题
【多选题】
查询每个学生获得最高成绩的课程号,关于“select sno, cno, max(grade) mgrade from sc group by sno”语句,说法正确的有( )
A.
该语句是正确的
B.
该语句不对，因为cno没有包含在聚集函数或group by 子句中
C.
该语句可改为：（1）先建一个求每个学生最大成绩的视图，create view vmgrade as select sno,max(grade) mgrade from sc Group by sno; （2）再用这个学生的最高成绩找获得这个最高成绩的课程号 select sc.sno, cno from sc, vmgrade where sc.sno=vmgrade.sno and sc.grade=vmgrade.mgrade
D.
该语句可改为基于派生表的查询，以实现 select sno, cno from sc, (select  sno, max(grade)   from sc  group by sno) as max_sc(sno, grade) where sc.sno=max_sc.sno and sc.grade>=max_sc.grade
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案：
举一反三
【简答题】. She returned to him the money she’d stolen for the sake of her _______. A. conference   B  convenience   C. consequence   D. conscience
查看完整题目与答案
【多选题】Among the statement about the University of Oxford, try to find out the true one(s).
A.
As the oldest university in UK, the University of Oxford is a famous and historic institution.
B.
There are 38 Oxford colleges(学院 ), which are financially independent and self-governing,but relate to the central University .
C.
The University awards degrees to students.
D.
Colleges organi z e tutorial (大学导师的) teaching for undergraduates.
查看完整题目与答案
【简答题】Introductory Lecture to University Study This lecture is about the structure of the university and about some of the requirements of the Bachelor of Social Science . First , the structure of the unive...
查看完整题目与答案
【判断题】机动车仪表板上（如图所示）亮表示发动机可能机油量不足。
A.
正确
B.
错误
查看完整题目与答案
【单选题】客房标准间走客房的清扫时间是( )。
A.
10—20分钟
B.
20—30分钟
C.
30—40分钟
D.
40—50分钟
查看完整题目与答案
【单选题】Which university offers courses through one of the BBC' s television channel?
A.
Open University.
B.
Cambridge University.
C.
Oxford University.
D.
Buckingham University.
查看完整题目与答案
【单选题】One ’ s university days often appear happier in ______ than they actually were at the time.
A.
retention
B.
retrospect
C.
return
D.
revere
查看完整题目与答案
【单选题】Which university is the oldest one in the U.S.?
A.
Yale University
B.
Harvard University
C.
Princeton University
D.
MIT
查看完整题目与答案
【单选题】Our university has one of the most___financial support programs in the US to ensure that students can meet the cost of their college education, regardless of background.
A.
extend
B.
extent
C.
extensive
D.
extending
查看完整题目与答案
【单选题】以下关于对住客房的清扫操作，描述正确的是哪项（）？
A.
打扫住客房与走客房的清洁标准有所不同，对于客人没有使用的设备和部位，可以不用再次清洁
B.
打扫住客房不得乱动客人的任何物品，整理客人放在写字桌上的笔记本等，不要弄错位置，更不准翻看
C.
清洁住客房时，如有来电，需及时接听，并将接听内容写在留言条上，由前厅经理封装好后，转交给客人
D.
客人如有留在取电插座上的取电卡，房间打扫结束后，服务员不应拔出断电后搁置在取电插座上
查看完整题目与答案
相关题目：
【简答题】. She returned to him the money she’d stolen for the sake of her _______. A. conference   B  convenience   C. consequence   D. conscience
查看完整题目与答案
【多选题】Among the statement about the University of Oxford, try to find out the true one(s).
A.
As the oldest university in UK, the University of Oxford is a famous and historic institution.
B.
There are 38 Oxford colleges(学院 ), which are financially independent and self-governing,but relate to the central University .
C.
The University awards degrees to students.
D.
Colleges organi z e tutorial (大学导师的) teaching for undergraduates.
查看完整题目与答案
【简答题】Introductory Lecture to University Study This lecture is about the structure of the university and about some of the requirements of the Bachelor of Social Science . First , the structure of the unive...
查看完整题目与答案
【判断题】机动车仪表板上（如图所示）亮表示发动机可能机油量不足。
A.
正确
B.
错误
查看完整题目与答案
【单选题】客房标准间走客房的清扫时间是( )。
A.
10—20分钟
B.
20—30分钟
C.
30—40分钟
D.
40—50分钟
查看完整题目与答案
【单选题】Which university offers courses through one of the BBC' s television channel?
A.
Open University.
B.
Cambridge University.
C.
Oxford University.
D.
Buckingham University.
查看完整题目与答案
【单选题】One ’ s university days often appear happier in ______ than they actually were at the time.
A.
retention
B.
retrospect
C.
return
D.
revere
查看完整题目与答案
【单选题】Which university is the oldest one in the U.S.?
A.
Yale University
B.
Harvard University
C.
Princeton University
D.
MIT
查看完整题目与答案
【单选题】Our university has one of the most___financial support programs in the US to ensure that students can meet the cost of their college education, regardless of background.
A.
extend
B.
extent
C.
extensive
D.
extending
查看完整题目与答案
【单选题】以下关于对住客房的清扫操作，描述正确的是哪项（）？
A.
打扫住客房与走客房的清洁标准有所不同，对于客人没有使用的设备和部位，可以不用再次清洁
B.
打扫住客房不得乱动客人的任何物品，整理客人放在写字桌上的笔记本等，不要弄错位置，更不准翻看
C.
清洁住客房时，如有来电，需及时接听，并将接听内容写在留言条上，由前厅经理封装好后，转交给客人
D.
客人如有留在取电插座上的取电卡，房间打扫结束后，服务员不应拔出断电后搁置在取电插座上
查看完整题目与答案
参考解析：
知识点：
题目纠错 0
发布
创建自己的小题库 - 刷刷题