11题

11. View the Exhibit and examine the structure of the PRODUCTS table.
All products have a list price. 
You issue the following command to display the total price of each product after a discount of 25% and a

tax of 15% are  applied on it. Freight charges of $100 have to be applied to all the products.
SQL>SELECT prod_name, prod_list_price -(prod_list_price*(25/100))                 
+(  prod_list_price -  ( prod_list_price*(25/100) )*(15/100)  )+100                                 
AS "TOTAL PRICE" 
FROM products; 
What would be the outcome if all the parenthese s are removed from the above statement?

 

A. It produces a syntax error.
B. The result remains unchanged. 
C. The total price value would be lower than the correct value. 
D. The total price value would be higher than the correct value.

题目里的那个SQL貌似不对呀
不应该是
SELECT prod_name, prod_list_price -  prod_list_price*(25/100)
+(   prod_list_price -   prod_list_price*(25/100)     )*(15/100)+100 
AS "TOTAL PRICE" 
FROM products; 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29574637/viewspace-1152805/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29574637/viewspace-1152805/