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

Correct Answer: SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

Make the most of this question

This page focuses on one SQL Server MCQs question from Programming. After checking the answer, return to the topic list to practice more or run a timed set.

SQL Server MCQs MCQ: 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”? | Extra Education