Home »
MCQs »
Transact-SQL (T-SQL) MCQs
What will be the output of the below LIKE query (2)?
11. What will be the output of the below LIKE query?
WHERE SALARY LIKE '%9000%'
- It will find any value that starts with 9000
- It will find any value that ends with 9000
- It will find any value that has 9000 at any position.
- It will find the value where salary is less than 9000
Answer: C) It will find any value that has 9000 at any position.
Explanation:
It will find any value that has 9000 at any position.