Division

Division operator.

Returns the quotient of two numeric operands.

Category: binary

SQL symbol: /

Example

SELECT 1.5 / 1.5; -- expected: 1.0

Signatures

  • decimal / decimal → decimal
  • decimal / integer → decimal
  • double / double → double
  • double / integer → double
  • integer / decimal → double
  • integer / double → double
  • integer / integer → double

Types

  • Left: decimal, double, integer
  • Right: decimal, double, integer
  • Result: decimal, double