Sql - ROUND, ABS and CAST
📖 Read the lesson
Code Life
By Pierre Marsaa
ROUND
Codemon's weights were measured with decimals.
ROUND(x, n)
keeps
n
decimals — none when
n
is omitted:
↗️
Loading editor...
↶
▶️ Run
↷
You already used
ROUND
on averages; it matters even more when the data itself has decimals:
↗️
Loading editor...
↶
▶️ Run
↷
ROUND returns a REAL
ROUND(
7.0
)
gives
7.0
, not
7
, and
ROUND(
4.5
)
gives
5.0
(halves round away from zero). To get an integer, combine with
CAST
, coming up in this chapter.
Verify