Algebra and Trigonometry Functions
A variety of commonly used math functions are available. They all operate on FLOAT
values. SQL
Notebook-specific functions are listed below. Refer to the SQLite documentation for the list of SQLite's built-in math functions.
Syntax
ROUND(x)
SIGN(x)
Example
PRINT SIGN(-1.6); -- "-1"
PRINT ROUND(5.5); -- "6"