COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which operator performs pattern matching?
|
|
BETWEEN operator
|
|
|
LIKE operator
|
|
|
EXISTS operator
|
|
|
None of these
|
Explanation:
Detailed explanation-1: -The correct answer to the question “Which operator performs pattern matching in SQL” is option (b). LIKE operator.
Detailed explanation-2: -LIKE operator is used for pattern matching, and it can be used as-. % – It matches zero or more characters.
Detailed explanation-3: -The LIKE operator provides standard pattern matching in SQL that is always used after a WHERE clause. It matches any pattern based on some conditions provided using the wildcard characters.
There is 1 question to complete.