SQL Comparison Operators

  • equal =
  • Not equal != or
  • Grater >
  • Less than
  • Grater than are equal >=
  • Less than are equal

 
equal =

query returns results when both value are equal.


 

Not Equal !=

query returns results when both value are Not equal.


 
Not Equal is as equal as != (Not equal)

query returns results as same as !=


 
Grater than >

It returns results grater then the value what we specify in where clause as part of the SQL query.


 
Less Than

It returns results Less then the value what we specify in where clause as part of the SQL query.

Now you try with either Grater than or Equal to (or) less than are equal to. by yourself.