Which quer ...
Terms and Conditions
Which query will select all records from
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'
SQL matches % wildcard to zero, one, or several characters in a string.
Which wildcard character in queries containing LIKE operator matches arbitrary n...
Pick all queries equivalent to the following one: select ...
Employees table has an VehicleNum column. It is of a varchar type and is used to...
In following query: SELECT * FROM employees ...
Select all types with which LIKE operator may be used....
Login to learn SQL
Read more about
Sign Up Now
Subscribe for future quizzes