ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-268

047-268

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 14:34:56 0 删除 编辑
268. View the Exhibit and examine the description of the ORDERS table.
The orders in the ORDERS table are placed through sales representatives only.
You are given the task to get the SALES_REP_ID from the ORDERS table of those
sales representatives who have successfully referred more than 10 customers.
Which statement would achieve this purpose?
A. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders HAVING COUNT(customer_id) > 10;
B. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders WHERE COUNT(customer_id) > 10
GROUP BY sales_rep_id;
C. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders GROUP BY sales_rep_id
HAVING total > 10;
D. SELECT sales_rep_id, COUNT(customer_id) "Total"
FROM orders GROUP BY sales_rep_id
HAVING COUNT(customer_id) > 10;
Answer: D

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-719019/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-267
下一篇: 047-271
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    213884