With SQL, how do you select all the columns from a table named 'Persons'?
SELECT [all] FROM Persons
SELECT * FROM Persons
SELECT *.Persons
SELECT Persons
To select all the columns from a table named 'Persons' using SQL, the user needs to use the following query:
B. SELECT * FROM Persons
Option A is incorrect because the SQL keyword for selecting all columns is not 'all,' but rather '*'.
Option C is incorrect because the '*' should come before the table name, and not after it.
Option D is incorrect because 'Persons' alone does not specify which columns to select from the table.
Therefore, the correct answer is option B.