SQL Comparison Operators:
>=
Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true. (a >= b) is not true.
>
Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true. (a > b) is not true.
<=
Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true. (a <= b) is true.
<
Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true. (a < b) is true.
!>
Checks if the value of left operand is not greater than the value of right operand, if yes then condition becomes true. (a !> b) is true.
!<
Checks if the value of left operand is not less than the value of right operand, if yes then condition becomes true. (a !< b) is false.
<>
Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. (a <> b) is true.
!=
Checks if the values of two operands are equal or not, if values are not equal then condition becomes true.(a != b) is true.
=
Checks if the values of two operands are equal or not, if yes then condition becomes true. (a = b) is not true.