OCP-1Z0-051-V9 02-141题

本是古典 何须时尚 2022-03-20 08:07 239阅读 0赞
  1. 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.)

SouthEast

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

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12879585

题意要求显示有最高credit limit的用户的名称和等级。

A，缺少 cust_credit_limit BETWEEN startval AND endval这个条件。

BC，使用的非等值连接

D有语法错误，WHERE子句里不能使用组函数

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow

发表评论

表情：
评论列表 （有 0 条评论，239人围观）

还没有评论，来说两句吧...

相关阅读

    相关 OCP-1Z0-051-V9 02-146题

    分享一下我老师大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjuns

    墨蓝墨蓝/ 0 赞/ 233 阅读