With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?
A. SELECT * FROM Persons WHERE FirstName=’a’
B. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
C. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
D. SELECT * FROM Persons WHERE FirstName=’%a%’
Answer:A
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?
A. SELECT * FROM Persons WHERE FirstName=’a’ B. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’ C. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’ D. SELECT * FROM Persons WHERE FirstName=’%a%’