ITPub博客

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

047-115

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 09:23:56 0 删除 编辑
115. View the Exhibit and examine the details of the PRODUCT_INFORMATION
table.You have the requirement to display PRODUCT_NAME and LIST_PRICE from
the table where the CATEGORY_ID column has values 12 or 13, and the
SUPPLIER_ID column has the value 102088. You executed the following SQL
statement: SELECT product_name, list_price FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;
Which statement is true regarding the execution of the query?
A. It would execute but the output would return no rows.
B. It would execute and the output would display the desired result.
C. It would not execute because the entire WHERE clause condition is not
enclosed within the parentheses.
D. It would not execute because the same column has been used in both sides
of the AND logical operator to form. the condition.
Answer: A
AND 应该换为or

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205811