In the customers table, the CUST_CITY column contains the value ‘Paris’ for the CUST_FIRST_NAME
‘Abigail’.
Evaluate the following query:
What would be the outcome?
A.
Abigail PA
B.
Abigail Pa
C.
Abigail IS
D.
An error message
What would be the outcome?
In the customers table, the CUST_CITY column contains the value ‘Paris’ for the CUST_FIRST_NAME
‘Abigail’.
Evaluate the following query:
What would be the outcome?
karan
February 8, 2016 at 12:46 am
-Length(‘Paris”) = -5 = 5th character from last.
(‘Paris’,-5,2) = P is the 5th character from last character and 2 char to be selected = Pa