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

Question

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'

Answer 1

Answer:
SELECT * FROM CUSTOMER WHERE STATE = 'CA' OR 'TX'