Asked by Diego Lopez on May 19, 2024
Verified
Rafael needs to run a query that will show the name and city of all his clients.Which of the following phrases will determine which fields are returned in the query?
A) FROM Name, City
B) SELECT Name, City
C) VALUES Name, City
D) WHERE Name, City
SELECT
A SQL command used to retrieve data from a database.
Fields
Defined areas in databases or software interfaces where specific types of data can be entered or manipulated.
- Comprehend the principles and uses of SQL queries in database management.
Verified Answer
AK
allison kellyMay 25, 2024
Final Answer :
B
Explanation :
The SELECT statement is used to choose which fields to return in a query, so option B is the correct answer. The other options are not appropriate for this purpose.
Learning Objectives
- Comprehend the principles and uses of SQL queries in database management.