SQL Basics: Truncating

Given the following table 'decimals':

decimals table schema

• id
• number1
• number2

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

 

 

Solution:

SELECT 
  TRUNC(number1 + number2) AS towardzero 
FROM 
  decimals

 

 

Result:

towardzero

1

2

0

2

2

1

 

 

Reference:

ROUND / TRUNC / MOD 반올림과 버림 그리고 나머지값 구하기