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'?
Explanation
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.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback