Kata SQ

SQL Basics: Truncating

Given the following table ‘decimals’:

** decimals table schema **

• id
• number1
• number2

Return a table with one column (towardzero) where the values are the result of number1 + number2 truncated towards zero.

Hint: The syntax should be “TRUNC” instead of “TRUNCATE”

Solution:

select trunc(number1+number2) as towardzero from decimals;

Link

Reference