Multiple choice technology databases

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

  1. SELECT * FROM Persons WHERE FirstName='Peter'

  2. SELECT [all] FROM Persons WHERE FirstName='Peter'

  3. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

  4. SELECT * FROM Persons WHERE FirstName<>'Peter'
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The standard SQL query to retrieve exact matches uses the '=' operator. SELECT * retrieves all columns from the table. The keyword [all] is not standard SQL syntax for selecting columns, and '<>' signifies 'not equal to'.

Keep practicing — related questions