ocpÌâ¿â½âÎö£º1Z0-051-V9.02-µÚ145Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

145. View the Exhibit and examine the structure of the CUSTOMERS table.

You issue the following SQL statement on the CUSTOMERS table to display the customers who are in the

same country as customers with the last name 'KING' and whose credit limit is less than the maximum СÓÚ×î´óÖµ

credit limit in countries that have customers with the last name 'KING':

SQL> SELECT cust_id,cust_last_name

FROM customers

WHERE country_id IN(SELECT country_id

FROM customers

WHERE cust_last_name ='King')

AND cust_credit_limit < (SELECT MAX(cust_credit_limit)

FROM customers

WHERE country_id IN(SELECT country_id

FROM customers

WHERE cust_last_name='King'));

Which statement is true regarding the outcome of the above query?

A. It executes and shows the required result.

B. It produces an error and the < operator should be replaced by < ALL to get the required output.

C. It produces an error and the < operator should be replaced by < ANY to get the required output.

D. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main

query to get the required output.

Answer: A

ÊÔÌâ½âÎö£º

1¡¢Ê×ÏÈÕÒ³öthe last name 'KING'ËùÔÚcountries

2¡¢ÔÙÕÒ³öKINGËùÔÚ³ÇÊеÄ×î´óµÄcust_credit_limit

3¡¢ÔÙÕÒ³öºÍKINGËùÔÚÒ»Ñù³ÇÊеĿͻ§µÄidºÍÐÕÃû£¬ËûÃǵÄcust_credit_limitҪСÓÚKINGËùÔÚ³ÇÊеÄ×î´óµÄcust_credit_limitµÄÆäÓàµÄÖµ¡£

ֵ̫¶à£¬È¥Ç°5¸ö¡£°´ÌâÒ⣬ѡA¡£