table?

Which of the following SQL statements will select the fields name and address from the contacts

table?
A . SELECT (name, address) FROM contacts;
B . SELECT (name address) FROM contacts;
C . SELECT name, address FROM contacts;
D . SELECT name address FROM contacts;

View Answer

Answer: C

Explanation:

The correct syntax for selecting specific columns from a table in SQL is to use the SELECT keyword followed by a comma-separated list of column names and then the FROM keyword followed by the table name. Therefore, the only option that follows this syntax is

C. SELECT name, address FROM contacts; The other options are incorrect because they either use parentheses around the column names, which are not needed, or they omit the comma between the column names, which causes a syntax error.

Reference: https://www.sqltutorial.org/sql-select/

https://www.w3schools.com/mysql/mysql_select.asp