[solved] – 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 Answer

---