由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - 刚做了70-433一道题,觉得答案有问题
相关主题
SQL 请教请教个SQL问题
怎么用Update实现这个?请教: SQL SUM
sql面试题1求教sqlzoo euro 2012 第十三题 (转载)
sql面试题3问一个query
再问个 subquery的问题请教一下怎么把这两句sql改写成subquery?
怎么求和Access 数据库查询
MS SQL Group By Questionoracle求助
An Access report question....有搞SQL 2008认证的么
相关话题的讨论汇总
话题: select话题: 答案话题: amounts话题: charity
进入Database版参与讨论
1 (共1页)
m******y
发帖数: 588
1
题目看起来很简单,但是想不通答案怎么会是D. 我觉得应该是B. 请问大侠们觉得哪个
是正确答案。谢谢!
Your company appoints you to serve for a charity organization which is named
AngelPlan. According to the requirement of the charity organization, they
want to view the highest 100 different amounts that were donated. So you are
writing a query to list the 100 amounts. You have written the code segment
below. (Line numbers are used for reference only):
1 SELECT *
2 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven,
3
4 FROM Custo
B*****g
发帖数: 34098
2
在这里贴题是不合适的。
Z*****l
发帖数: 14069
3
完了,俺也觉得应该是B,D那个就是所有人都显示了么。

named
are
segment

【在 m******y 的大作中提到】
: 题目看起来很简单,但是想不通答案怎么会是D. 我觉得应该是B. 请问大侠们觉得哪个
: 是正确答案。谢谢!
: Your company appoints you to serve for a charity organization which is named
: AngelPlan. According to the requirement of the charity organization, they
: want to view the highest 100 different amounts that were donated. So you are
: writing a query to list the 100 amounts. You have written the code segment
: below. (Line numbers are used for reference only):
: 1 SELECT *
: 2 FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven,
: 3

1 (共1页)
进入Database版参与讨论
相关主题
有搞SQL 2008认证的么 再问个 subquery的问题
recursive sql?怎么求和
A sql questionMS SQL Group By Question
新手请教ACCESS的SUM功能An Access report question....
SQL 请教请教个SQL问题
怎么用Update实现这个?请教: SQL SUM
sql面试题1求教sqlzoo euro 2012 第十三题 (转载)
sql面试题3问一个query
相关话题的讨论汇总
话题: select话题: 答案话题: amounts话题: charity