CompTIA Tech+ FC0-U71 Practice Question
As a junior database analyst, you've been asked to retrieve the list of all customers from a 'Customers' table who are located in Paris. Which command should you use to accomplish this task?
SELECT city FROM Customers WHERE city = 'Paris';
SELECT * FROM Customers WHERE location = 'Paris';
SELECT * FROM CustomerList WHERE city = 'Paris';
SELECT * FROM Customers WHERE city = 'Paris';