Employees table has an VehicleNum column. It is of a varchar type and is used to store vehicle numbers (for example, 'A338МВ38').
Which condition should be used to fetch a vehicle number whose third and firth characters are '74'?
WHERE VehicleNum LIKE ‘_74%’ is the correct answer
"_" symbol replaces single character in a string.
"%" symbol replaces character sequence of arbitrary length.
Therefore, '_74%' pattern will return all records whose second and third characters are 7 and 4 correspondingly.

Слідкуй за CodeGalaxy

Мобільний додаток Beta

Get it on Google Play
Зворотній Зв’язок
Зареєструйся Зараз
або Підпишись на майбутні тести