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

141. View the Exhibit and examine the structure of CUSTOMERS and GRADES tables.

You need to display names and grades of customers who have the highest credit limit.

Which two SQL statements would accomplish the task? (Choose two.)

A. SELECT custname, grade

FROM customers, grades

WHERE (SELECT MAX(cust_credit_limit)

FROM customers) BETWEEN startval and endval;

B. SELECT custname, grade

FROM customers, grades

WHERE (SELECT MAX(cust_credit_limit)

FROM customers) BETWEEN startval and endval

AND cust_credit_limit BETWEEN startval AND endval;

C. SELECT custname, grade

FROM customers, grades

WHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)

FROM customers)

AND cust_credit_limit BETWEEN startval AND endval;

D. SELECT custname, grade

FROM customers , grades

WHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)

FROM customers)

AND MAX(cust_credit_limit) BETWEEN startval AND endval;

Answer: BC

ÊÔÌâ½âÎö£º

ÌâÒâÒªÇóÏÔʾÓÐ×î¸ßcredit limitµÄÓû§µÄÃû³ÆºÍµÈ¼¶¡£

A£¬È±ÉÙcust_credit_limit BETWEEN startval AND endvalÕâ¸öÌõ¼þ¡£

BC£¬Ê¹ÓõķǵÈÖµÁ¬½Ó

DÓÐÓï·¨´íÎó£¬WHERE×Ó¾äÀï²»ÄÜʹÓÃ×麯Êý