Basic SQL Quiz - 2

Casual Mode - Take your time!

1 / 20
Correct
0
Incorrect
0
Score
0%
Multiple Choice

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

  1. SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
  2. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
  3. SELECT FirstName='Peter', LastName='Jackson' FROM Persons
Change Mode