Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
A. SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
B. SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
C. SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
D. SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);
Answer:A
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
A. SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’); B. SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’; C. SELECT NAME IN CUSTOMER WHERE STATE = ‘V’; D. SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);
Explanation: Query d satisfy the condition mention in above.