OCP-1Z0-051 第62题 where通配符

最新推荐文章于 2022-05-10 15:33:49 发布

hello_holly

最新推荐文章于 2022-05-10 15:33:49 发布

阅读量5.2k

点赞数 2

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 BETWEEN AND 通配符 ocp

本文链接：https://blog.csdn.net/holly2008/article/details/24706979

版权

本文通过比较在Oracle数据库中使用BETWEEN AND和LIKE通配符查询的区别，讨论了在筛选以特定字符开头的数据时的正确方法。在给定的示例中，使用BETWEEN AND无法正确地获取以'A', 'B'或'C'开头的客户信息，而LIKE通配符则能提供正确的结果。" 107730217,9664483,C++实现复数实部与虚部处理,"['C++', '编程']

摘要由CSDN通过智能技术生成

一、原题

View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000.
Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_credit_limit
             FROM customers
         WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%' OR UPPER(cust_last_name) LIKE 'C%')
               AND cust_credit_limit < 10000;
SQL>SELECT cust_last_name, cust_credit_limit FROM customers
         WHERE UPPER(cust_last_name) BETWEEN 'A' AND 'C'
              AND cust_credit_limit < 10000;
Which statement is true regarding the execution of the above queries?