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

Question

TuteeHUB · Accepted Answer

SELECT * FROM Persons WHERE FirstName=’%a%’

TuteeHUB · Answer

SELECT * FROM Persons WHERE FirstName=’a’

TuteeHUB · Answer

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

TuteeHUB · Answer

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

1.	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» D. SELECT * FROM Persons WHERE FirstName=’%a%’

Discussion