Join ExamsbookAnswer : 1. "LIKE operator"
Which operator performs pattern matching ?5
Q: Which operator performs pattern matching ?
- 1LIKE operatortrue
- 2EXISTS operatorfalse
- 3BETWEEN operatorfalse
- 4None of thesefalse
- Show AnswerHide Answer
- Workspace
Answer : 1. "LIKE operator"
Explanation :
Answer: A) LIKE operator Explanation: LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN). The syntax is as follows:SELECT "column_name"FROM "table_name"WHERE "column_name" LIKE {PATTERN} {PATTERN} often consists of wildcards. In SQL, there are two wildcards: % (percent sign) represents zero, one, or more characters. _ (underscore) represents exactly one character. More :: Certification Questions on SQL