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 &ldquo;Persons&rdquo; where the value of the column &ldquo;FirstName&rdquo; ends with an &ldquo;a&rdquo;?

Admin · Accepted Answer

SELECT * FROM Persons WHERE FirstName LIKE &lsquo;%a&rsquo;

Admin · Answer

SELECT * FROM Persons WHERE FirstName=&rsquo;%a%&rsquo;

Admin · Answer

SELECT * FROM Persons WHERE FirstName LIKE &lsquo;a%&rsquo;

Admin · Answer

SELECT * FROM Persons WHERE FirstName=&rsquo;a&rsquo;

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

Discusssion