With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
• SELECT * FROM Persons WHERE FirstName=’%a%’
• SELECT * FROM Persons WHERE FirstName=’a’
• I don’t know

Answer:
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’