Multiple choice technology mainframe

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

  1. SELECT FirstName FROM Persons

  2. SELECT Persons.FirstName

  3. EXTRACT FirstName FROM Persons

  4. EXTRACT Persons.FirstName
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The basic SELECT syntax is 'SELECT column_name FROM table_name'. This directly retrieves all values from the specified column.

Keep practicing — related questions