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

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 ?

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

TuteeHUB · Answer

SELECT * FROM Persons WHERE FirstName= %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