Multiple choice technology databases

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='Peter',LastName='Jackson'

  2. SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

  3. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

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

To filter results based on multiple criteria that must all be met, the SQL AND operator is used. Using a comma in a WHERE clause is syntactically incorrect, and the OR operator would return records matching either name, not necessarily both.

Keep practicing — related questions