Mathematical Functions
These functions operate on numeric values.
Remainder/Modulo
Which function returns the remainder when one number, <num>, is divided by another, <base>?
IBM DB2
MOD(<num>, <base>)
MySQL
MOD(<num>, <base>) or <num> MOD <base> or <num> % <base>
Oracle
MOD(<num>, <base>)
Postgres
<num> % <base> or MOD(<num>, <base>)
SAS proc sql
MOD(<num>, <base>)
SQL Server
<num> % <base>
Power
How do you raise one number, <base>, to another number, <exp>?
IBM DB2
POWER(<base>, <exp>)
MySQL
POWER(<base>, <exp>)
Oracle
POWER(<base>, <exp>)
Postgres
POWER(<base>, <exp>) or <base>^<exp>
SAS proc SQL
<base>**<exp>
SQL Server
POWER(<base>, <exp>)
Natural Logs and Exponential Function
What are the functions for the natural log and exponential function...