In followi ...
Terms and Conditions
In following query:
SELECT * FROM employees
which condition should be ued to extract all records whose last_name start from 'SM'? Select all that apply.
WHERE last_name = 'SM'
WHERE last_name IS 'SM*'
WHERE last_name LIKE 'SM%'
WHERE last_name[1 TO 2] = 'SM'
WHERE last_name EQUATES TO 'SM'
Percent sign (%) represents zero, one, or multiple characters in SQL wildcards.
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...
Which query will select all records from Persons table whose FirstName...
Select all types with which LIKE operator may be used....
Login to learn SQL
Read more about
Sign Up Now
Subscribe for future quizzes