SQL quiz. Which query will select all records from <b>Person

Which query will select all records from Persons table whose FirstName value starts with "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName = 'a'

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

SELECT * FROM Persons WHERE FirstName STARTSWITH 'a'

Explanation

SQL matches % wildcard to zero, one, or several characters in a string.

like-operator

2 (2)

Like

Login in to like

Comment

Login in to comment

Share

Tweet

SQL
Quiz

Login to learn SQL

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback