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

Which of the following SQL statements will select the fields name and address from the contacts 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;

Explanation:
see http://www.sqlite.org/syntaxdiagrams.html#select-stmt for a detailed description of the SQL select syntax.



Leave a Reply 0

Your email address will not be published. Required fields are marked *