Which are SQL operators?

SQL have lots of operators in order to manipulate numeric and alphabetic datatypes.

Arithmetic operators:

• unary + and -
  
• +
  
• -
  
• *
  
• /
  

Comparison operators:

• = equal to
  
• !=, ^=, <> not equal to
• >, <, <=, >= greater/less than
  
• IN, NOT IN
  
• ANY, SOME, ALL
• BETWEEN, NOT BETWEEN
  
• EXISTS, NOT EXISTS
  
• LIKE, NOT LIKE
  
• IS NULL, IS NOT NULL

Logical operators

• AND binary
  
• OR binary
  
• NOT unary

Set operators

• UNION
• UNION ALL
• INTERSECT
• MINUS