051-127

最新推荐文章于 2024-07-15 19:48:15 发布

dieqiao8331

最新推荐文章于 2024-07-15 19:48:15 发布

阅读量130

点赞数

原文链接：http://www.cnblogs.com/Babylon/p/7922069.html

版权

Examine the data in the CUSTOMERS table:
　　　　　　　　　　　　　　　　 CUSTNO CUSTNAME CITY

1	KING	SEATTLE
2	GREEN	BOSTON
3	KOCHAR	SEATTLE
4	SMITH	NEW YORK

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:
SQL>SELECT c1.custname, c1.city
FROM Customers c1 __________________ Customers c2
ON (c1.city=c2.city AND c1.custname<>c2.custname);
Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose
two.)
A. JOIN
B. NATURAL JOIN
C. LEFT OUTER JOIN
D. FULL OUTER JOIN
E. RIGHT OUTER JOIN

　　这里解释一下E答案，由于是右外连接，显示 C2 表所有的数据，并且显示 C1 表满足条件的数据，因为 SELECT 语句的列表中没有 C2的列，所以这里只显示了 C1 的两个满足条件的记录加两条空记录。感觉又是一个擦边球。

转载于:https://www.cnblogs.com/Babylon/p/7922069.html