Q. With SQL, how do you select all the records from a table named “Persons” where the valueof the column “FirstName” ends with an “a”? (Solved)
1. SELECT * FROM Persons WHERE FirstName=’a’
2. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
3. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
4. SELECT * FROM Persons WHERE FirstName=’%a%’
- c. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’