Multiple choice technology databases

With SQL, how do you select all the columns from a table named "Persons"?

  1. SELECT *.Persons

  2. SELECT Persons

  3. SELECT * FROM Persons

  4. SELECT [all] FROM Persons
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The correct syntax is SELECT * FROM table_name, where * means 'all columns' and FROM specifies the table. SELECT *.Persons and SELECT Persons are invalid - SQL requires the FROM keyword to separate columns from the table name.

Keep practicing — related questions