Home »
MCQs »
Transact-SQL (T-SQL) MCQs
What will be the output of the below LIKE query (4)?
13. What will be the output of the below LIKE query?
WHERE SALARY LIKE '_10%8'
- It will find any value that has a 10 at the starting position and ends with 8.
- It will find any value that has a 10 in the second position and ends with 8.
- It will find any value that has a 10 in the third position and also has 8.
- It will find any value that has a 10 in the second position and starts with 8.
Answer: B) It will find any value that has a 10 in the second position and ends with 8.
Explanation:
It will find any value that has a 10 in the second position and ends with 8.