जॉइन Examsbook
2597 0

प्र: Which operator performs pattern matching ?

  • 1
    LIKE operator
  • 2
    EXISTS operator
  • 3
    BETWEEN operator
  • 4
    None of these
  • उत्तर देखें
  • Workspace

उत्तर : 1. "LIKE operator"
व्याख्या :

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

पिछला अगला

क्या आपको यकीन है

  त्रुटि की रिपोर्ट करें

कृपया संदेश दर्ज करें
त्रुटि रिपोर्ट सफलतापूर्वक जमा हुई