本文探讨了在使用SQL进行数据查询时常见的错误及其原因，通过具体案例分析，如在PRODUCTS表中筛选特定条件的产品信息，解释了如何正确设置查询条件以避免返回空结果，强调了对NULL值的正确处理。
分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！
59. View the Exhibit and examine the data in the PRODUCTS table.
You need to display product names from the PRODUCTS table that belong to the 'Software/Other '
category with
minimum prices as either $2000 or $4000 and no unit of measure.
You issue the following query:
SQL>SELECT prod_name, prod_category, prod_min_price
FROM products
WHERE prod_category LIKE '%Other%' AND (
prod_min_price = 2000 OR
prod_min_price = 4000) AND prod_unit_of_measure
<> '';
Which statement is true regarding the above query?
A. It executes successfully but returns no result.
B. It executes successfully and returns the required result.
C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
Answer: A
答案解析：
实验验证：
SELECT prod_name, prod_category, prod_min_price
2 FROM products
3 WHERE prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR
4 prod_min_price = 4000) AND prod_unit_of_measure <> '';
no rows selected
prod_unit_of_measure
<> ''; 应该改为is not null
因为prod_unit_of_measure <> ''该条件为假，’’相当于NULL，所以会导致该WHERE子句里所有AND连接的值为假，
虽然执行成功但不会返回结果，正确的条件应该是prod_unit_of_measure is not null。
给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
