Question

Which of the following is a comparison operator in SQL?
(A) =
(B) LIKE
(C) BETWEEN
(D) All of the above
​

Answer 1

Of all the options, options A (=) is the comparison operator in SQL. Comparison operators are used to checking whether two expressions are the same. Comparison operators in SQL can be used for all expressions but the expressions of the text, ntext, or image data types.