63 812
Assignments Done
99,5%
Successfully Done
In August 2018

Answer to Question #76377 in Databases | SQL | Oracle | MS Access for J

Question #76377
Table CUSTOMER has all customers, and it has a column STATE for the Customer Address' State. What statement below would return all customers from California ('CA') and Texas ('TX')?


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA'

OR STATE = 'TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA' OR 'TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA','TX'


SELECT *

FROM CUSTOMER

WHERE STATE = 'CA'

AND STATE = 'TX'
Expert's answer
Answer:
SELECT * FROM CUSTOMER WHERE STATE = 'CA' OR 'TX'

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions