Which of the following is not a comparison query?
(A) IN
(B) BETWEEN
(C) LIKE
(D) AND
Answer:
|
Comparison Keyword |
Description |
|
LIKE |
Checks if column value is similar to the specified pattern. |
|
IN |
Checks if column value is equal to any one of a specified set of values. |
|
BETWEEN |
Checks if column value is between two values, including the end values specified in the range. |
|
IS NULL |
Checks if column value is null. |
Checking the options
- (A) IN - It is a comparison keyword
- (B) BETWEEN - It is a comparison keyword
- (C) LIKE - It is a comparison keyword
- (D) AND - It is not a comparison keyword
So, the correct answer is (D)
