Question

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

Answer 1

c is your answer......

Answer 2

Answer: (c) =

Concept : Comparison operator in SQL

Given : (a) LIKE

            (b) BETWEEN

            (c) =

            (d) All of the above

To Find : Which of the following is a comparison operator in SQL?

Explanation :

Comparison operators are the mathematical symbols that are used to compare two values. Comparison operators are used when one have to compare two expressions . A comparison operator usually returns a true or a false value. The comparison operators in SQL are -

• =  : equal to, it return true when two values are equal
• >  : greater than, it returns true when left operand is greater than the right operand
• <  : less than, it returns true when right operand is lesser than the left operand
• >=  : greater than equal to, it returns true when either the left operand is greater than or equal to the right operand
• <=  : less than equal to, it returns true when either the right operand is lesser than or equal to the left operand
• <>  : not equal to

#SPJ3