Computer Science
Which operator performs pattern matching ?
- BETWEEN operator
- LIKE operator
- EXISTS operator
- None of these
SQL Queries
3 Likes
Answer
LIKE operator
Reason — SQL includes a string-matching operator, LIKE, for comparisons on character strings using patterns.
Answered By
1 Like
Related Questions
Which of the following queries contains an error?
- Select * from emp where empid = 10003;
- Select empid from emp where empid = 10006;
- Select empid from emp;
- Select empid where empid = 1009 and lastname = 'GUPTA';
Consider the following table namely Employee :
Employee_id Name Salary 1001 Misha 6000 1009 Khushi 4500 1018 Japneet 7000 Which of the names will not be displayed by the below given query ?
SELECT name FROM employee WHERE employee_id > 1009 ;- Misha, Khushi
- Khushi, Japneet
- Japneet
- Misha, Japneet
Consider the following query
SELECT name FROM class WHERE subject LIKE ' ............... Computer Science' ;Which one of the following has to be added into the blank space to select the subject which has Computer Science as its ending string ?
- _
- ||
- \%
Which operator tests a column for the absence of data (i.e., NULL value) ?
- EXISTS operator
- NOT operator
- IS operator
- None of these