ocp题库解析：1Z0-051-V9.02-第141题
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子句里不能使用组函数
精华阅读