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?
The correct answer is SELECT * FROM Customers WHERE city = 'Paris'; because it specifically requests all records (noted by the asterisk *) from the 'Customers' table where the 'city' column matches the condition of being 'Paris'. The other options are incorrect because they either reference incorrect syntax, select from the wrong table, or filter by an incorrect condition.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does the asterisk (*) mean in the SQL query?
Open an interactive chat with Bash
Why is 'WHERE city = 'Paris'' important in the query?
Open an interactive chat with Bash
What might be the consequence of using an incorrect table name like 'CustomerList'?