SQL
Which quer ...
Site Language: English
Українська
English
Русский
Programming Tests
Login
Sign Up
Programming Tests
Theory
Snippets
Papers
Landing
Android
Prices
FAQ
Cosmo Story
Terms and Conditions
Privacy Policy
Cookies Policy
Send Feedback
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
S
QL
Quiz
Login to learn SQL
or
Read more about
SQL Quizzes
Follow CodeGalaxy
Mobile Beta
Send Feedback
Sign Up Now
or
Subscribe for future quizzes
Login in to like
Login in to comment