在Oracle SQL查询中，试图使用列别名`DISCOUNTED_PRICE`在WHERE子句过滤条件时导致错误。正确做法是将表达式`prod_list_price - (prod_list_price * .25)`直接用于WHERE子句，而不是使用别名。选项C是正确答案，因为列别名不能在定义它们的原始查询的WHERE子句中直接使用。
一、原题
View the Exhibit and examine the structure of the PRODUCTS table.
Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.
SQL>SELECT prod_name, prod_list_price,
prod_list_price - (prod_list_price * .25) "DISCOUNTED_PRICE"
FROM products
WHERE discounted_price < 10;
The query generates an error.What is the reason for the error?
A. The parenthesis should be added to enclose the entire expression.
B. The double quotation marks should be r
Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.
SQL>SELECT prod_name, prod_list_price,
prod_list_price - (prod_list_price * .25) "DISCOUNTED_PRICE"
FROM products
WHERE discounted_price < 10;
The query generates an error.What is the reason for the error?
A. The parenthesis should be added to enclose the entire expression.
B. The double quotation marks should be r
最低0.47元/天 解锁文章
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
