ITPub博客

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

047-151

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:11:58 0 删除 编辑
151. View the Exhibit and examine the structure of ORDERS and CUSTOMERS
tables.Which INSERT statement should be used to add a row into the ORDERS
table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is
600?
A. INSERT INTO orders VALUES (1,'10mar2007','direct',
(SELECT customer_id FROM customers
WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
B. INSERT INTO orders (order_id,order_date,order_mode,
(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND
credit_limit=600),order_total)
VALUES(1,'10mar2007','direct',&&customer_id, 1000);
C. INSERT INTO orders (order_id,order_date,order_mode,
(SELECT customer_id FROM customers
WHERE cust_last_name='Roberts' AND credit_limit=600),order_total)
VALUES(1,'10mar2007','direct', &customer_id, 1000);
D. INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id,
o.order_total FROM orders o, customers c
WHERE o.customer_id = c.customer_id
AND c.cust_last_name='Roberts' AND c.credit_limit=600 )
VALUES (1,'10mar2007','direct',(SELECT customer_id
FROM customers WHERE cust_last_name='Roberts' AND
credit_limit=600), 1000);
Answer: A
Eg: insert into dept values(6,4,(select ename from emp where emp_No=5));

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204342