how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"

technology databases

  1. SELECT * FROM Persons WHERE FirstName='%a%'

  2. SELECT * FROM Persons WHERE FirstName='a'

  3. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  4. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Show answer
Correct Option: D

Find more quizzes: