Sql - ROUND, ABS and CAST
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...
↶
↷
You already used ROUND on averages; it matters even more when the data itself has decimals:
↗️
Loading editor...
↶
↷
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