SQL_Operators1
 
  • Operation and Operator
    • Unary Operation
    • Binary  Operations
    • Set Operations : Union, Union All, Intersect, Intersect ALL, and Minus Operators
  • Arithmetic Operators
    •  + or - (unary ) , (/) division, (*) Multiplication, (+) Addition (numbers and dates), and (-) substantiation (number and dates)
  • Character Operation and Operators
  • Comparison Operation and Operators
    •  
  • Logical Operation and Operators
    • NOT, AND , OP Operators
Operator Precedence:
  1. Unary + - arithmetic operators, PRIOR operator
  2. * / arithmetic operators
  3. Binary + - arithmetic operators, || character operators
  4. All comparison operators
  5. NOT logical operator
  6. AND logical operator
  7. OR logical operator