你工作在一个售书公司.你正在基于SQL SERVER 2005数据库创建一个报表。此报表显示本月超过 销售配额的销售代表及他们的销售额 。已知，销售配额为$2,000。查询的起始日期和截至日期 以变量@FromDate 和 @ToDate 传递进来。为了实现满足上述条件的报表，你应该使用下面那一 个SQL查询语句？

单项选择题

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

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

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

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

查看答案         下一题 答案：C
【原题】：你工作在一个售书公司.你正在基于SQL SERVER 2005数据库创建一个报表。此报表显示本月超过 销售配额的销售代表及他们的销售额 。已知，销售配额为$2,000。查询的起始日期和截至日期 以变量@FromDate 和 @ToDate 传递进来。为了实现满足上述条件的报表，你应该使用下面那一 个SQL查询语句？

单项选择题

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

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

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

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

【解析】：

200题为1关，请收藏当前位置，方便下次学习。

第1关   119   120   121   122   123   124   125   126   127   128   129   130   131   132   133   134   135   136   137   138   139   140   141   142   143   144   145   146   147   148   149   150   151   152   153   154   155   156   157   158   159   160   161   162   163   164   165   166   167   168   169   170   171   172   173   174   175   176   177   178   179   180   181   182   183   184   185   186   187   188   189   190   191   192   193   194   195   196   197   198   199   200   第2关   第3关  

完整版《考试通关题库》请扫描下图二维码关注官方微信公众号，加入会员，即可打包下载！经广大会员朋友实战检验，使用本题库考试通过率大大提高！绝对是您考试通关的不二利器！