With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with a

Question

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

Answer 1

SELECT * FROM Persons
WHERE FirstName LIKE "a%";

By the way, I think you should revise your SQL course. Start from the beginning again.