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"?

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"? 




a. SELECT * FROM Persons WHERE FirstName='a'
b. SELECT * FROM Persons WHERE FirstName LIKE '%a'
c. SELECT * FROM Persons WHERE FirstName='%a%'
d. SELECT * FROM Persons WHERE FirstName LIKE 'a%'




Answer: D


Learn More :