sqlcmd.net validated sql reference

Tag archive

#math

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly
beginner math MySQL MariaDB SQL Server PostgreSQL SQLite

Compute Absolute Value and Remainder

Use `ABS` to strip the sign from a number and `MOD` (or the `%` operator) to get the integer remainder after division.

beginner math MySQL MariaDB SQL Server PostgreSQL SQLite

Round Numbers With ROUND, CEIL, and FLOOR

Control the precision or snapping of numeric results using `ROUND` for half-up rounding, `CEIL` to round up to the next integer, and `FLOOR` to round down.