Multiple choice

What does the following query do? SELECT * from Employee WHERE SALARY LIKE '_2%3'

  1. Finds any values that end with 2

  2. Finds any values that start with 2 and are at least 3 characters in length

  3. Finds any values in a five-digit number that start with 2 and end with 3

  4. Finds any values that have 2 in the second position and end with 3

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

As % denotes any number of digits or character,s it should be given between 2 and 3. 3 should be given at the end and 2 at second position, _2 SELECT * from Employee WHERE SALARY LIKE '_2%3'.

Keep practicing — related questions