SQL - Numeric Functions
Overview
Numeric functions include ABS, ROUND, CEIL/FLOOR, and others. SQLite supports ABS and ROUND; emulate some calculations directly.
SELECT ABS(-5), ROUND(3.14159, 2), CEIL(1.2), FLOOR(1.8);
SELECT ABS(-5), ROUND(3.14159, 2), CEILING(1.2), FLOOR(1.8);
SELECT ABS(-5), ROUND(3.14159, 2), CAST((1.2 + 0.9999) AS INT) AS ceil_approx, CAST(1.8 AS INT) AS floor_approx;
Prerequisite
Load the Standard Test Data.
Live Examples (SQLite)
| absval | pi2 |
|---|---|
| 5 | 3.14 |
Use case: salary rounding
| id | first_name | salary | salary_k |
|---|---|---|---|
| 5 | Eli | 130000 | 130.0 |
| 1 | Ada | 120000 | 120.0 |
| 4 | Dee | 110000 | 110.0 |
| 2 | Bob | 90000 | 90.0 |
| 3 | Chen | 80000 | 80.0 |