Part 103: Mathematical Functions: ROUND, CEIL, FLOOR, MOD & POWER

Executing numerical transformations inside SQL.

1. Mathematical Functions Table

SELECT 
  ROUND(125.4567, 2) AS rounded,   -- 125.46
  CEIL(4.01) AS ceiling_val,        -- 5
  FLOOR(4.99) AS floor_val,         -- 4
  MOD(10, 3) AS remainder_val,      -- 1
  POWER(2, 8) AS exponential_val,   -- 256
  SQRT(144) AS square_root          -- 12
;

Key Takeaways

• Use ROUND(val, decimal_places) to control display precision on averages.

In Part 104, we explore Date Extraction & Arithmetic: DATEADD, DATEDIFF, EXTRACT!