Using VoltDB

contents

EXP()

EXP() — Returns the exponential of the specified numeric expression.

Synopsis

EXP( numeric-expression )

Description

The EXP() function returns the exponential of the specified numeric expression. In other words, EXP(x) is the equivalent of the mathematical expression ex.

Example

The following example uses the EXP function to calculate the potential population of certain species of animal projecting out ten years.

SELECT species, population AS current,
       (population/2) * EXP(10*(gestation/365)*litter) AS future
       FROM animals 
       WHERE species = "rabbit"
       ORDER BY population;
contents