Easy SQL: Rounding Decimals

Given the following table 'decimals':

** decimals table schema **

• id
• number1
• number2

Return a table with two columns (number1, number2), the value in number1 should be rounded down and the value in number2 should be rounded up.

 

Solution:

SELECT 
  FLOOR(number1) as number1,
  CEIL(number2) as number2
FROM
  decimals

 

Result:

number1	number2
2409	-261
1411	-4694
2666	-2280
3616	-2987
4110	-2420
3654	-1463

 

Reference:

postgresql 의 반올림 함수들