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'
1
Expert's answer
2018-04-24T08:41:17-0400
Answer: SELECT * FROM CUSTOMER WHERE LASTNAME LIKE 'EST%'
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment