DIV0

Returns the quotient by dividing the first number by the second one. Returns 0 if the second number is 0.

See also:

• DIV
• DIVNULL

Syntax

DIV0(<number1>, <number2>)

Examples

SELECT
  DIV0(20, 6),
  DIV0(20, 0),
  DIV0(20, NULL);

┌───────────────────────────────────────────────────┐
│     div0(20, 6)    │ div0(20, 0) │ div0(20, null) │
├────────────────────┼─────────────┼────────────────┤
│ 3.3333333333333335 │           0 │ NULL           │
└───────────────────────────────────────────────────┘