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

Question

Table CUSTOMER has all customers, and it has a column LASTNAME for the Customer's last name. What statement below would return all customers whose last name begins with 'EST'?

SELECT *

FROM CUSTOMER

WHERE LASTNAME LIKE 'EST%'


SELECT *

FROM CUSTOMER

WHERE LASTNAME = 'EST%'


SELECT *

FROM CUSTOMER

WHERE LASTNAME = 'EST'


SELECT *

FROM CUSTOMER

WHERE LASTNAME = 'EST'

OR LASTNAME = 'ESTA'

Answer 1

Answer:
SELECT *
FROM CUSTOMER
WHERE LASTNAME LIKE 'EST%'