You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query? A) SELECT * FROM Customer WHERE State 'TX' B) SELECT * FROM Customer WHERE State not = 'TX' C) SELECT all FROM Customer WHERE State 'TX' D) SELECT all FROM Customer WHERE State not = 'TX'

Question

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query? A) SELECT * FROM Customer WHERE State <> 'TX' B) SELECT * FROM Customer WHERE State not = 'TX' C) SELECT all FROM Customer WHERE State <> 'TX' D) SELECT all FROM Customer WHERE State not = 'TX'

Quizplus · Accepted Answer

Option A is correct because it uses the correct SQL syntax to select all columns from the 'Customer' table where the 'State' column does not equal 'TX'. The syntax "<>" is used for "not equal to" in SQL.

You Need to Write a Query to Retrieve All Customer