The above query produces an error on execution. What is the reason for the error?
A. An alias cannot be used in an expression
B. The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression
C. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values
D. The alias NAME should not be enclosed within double quotation marks
Answer:A
The above query produces an error on execution. What is the reason for the error?
A. An alias cannot be used in an expression B. The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression C. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values D. The alias NAME should not be enclosed within double quotation marks