皮皮学，免费搜题
登录
搜题
【单选题】
你工作在一个售书公司.你正在基于SQL SERVER 2005数据库创建一个报表。此报表显示本月超过销售配额的销售代表及他们的销售额 。已知，销售配额为$2，000。查询的起始日期和截至日期以变量@FromDate 和 @ToDate 传递进来。为了实现满足上述条件的报表，你应该使用下面哪一个SQL查询语句？（）A.
SELECT s.AgentName，SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate GROUP BY s.AgentName
B.
SELECT s.AgentName，SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate AND o.OrderTotal >= 2000 GROUP BY s.AgentName
C.
SELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentID WHERE o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal） >= 2000
D.
SELECT s.AgentName,SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.ordertotal =2000 AND o.OrderDate BETWEEN @FromDate AND @ToDate GROUP BY s.AgentName HAVING SUM（o.OrderTotal）>= 2000
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【简答题】在桌面的空白处单击鼠标右键，;然后再弹出的快捷菜单中选择()命令可以设置桌 面的背景.
【简答题】钻孔时，由于切削深度已由钻头直径决定，所以只需选择（）和（）。
【单选题】有数组定义 double d[10]; 以下叙述不正确的是( )。
A.
（A）数组d有10个元素
B.
（B）数组d的最后一个元素是d[10]
C.
（C）数组d的第一个元素*d
D.
（D）数组d的字节数是sizeof(double)*10
【单选题】有数组定义 double d[10]; 以下叙述不正确的是( )。
A.
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">数组 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">d "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">有 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">10 "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">个元素
B.
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">数组 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">d "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">的最后一个元素是 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">d[10]
C.
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">数组 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">d "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">的第一个元素 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">*d
D.
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">数组 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">d "Times New Roman";mso-bidi-font-family:"Times New Roman";mso-ansi-language: EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">的字节数是 mso-fareast-font-family:宋体;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN; mso-bidi-language:AR-SA" xml:lang="EN-US">sizeof(double)*10
【简答题】在Windows桌面的空白处，单击鼠标右键会弹出快捷菜单，在快捷菜单中选择“属性”命令，则弹出______。
【简答题】平行承发包模式的缺点之一是（ ）。
相关题目：
参考解析：
知识点：
题目纠错 0
发布
