Returns “x modulus y”. This is the integral remainder of x divided by y.

This function returns an INTEGER datatype.

MOD( integral_expression, divisor_integral_expression )

integral_expression % divisor_integral_expression

Required. Any expression that returns a integer-class datatype. This value will be divided by the divisor_integral_expression.

Required. Any expression that returns a integer-class datatype. This value will be divided into the integral_expression.

> select population, mod(population, 100) from country_census;

POPULATION              MOD(COUNTRY_CENSUS.POP
----------------------  ----------------------
              28846761                      61
              30007094                      94
             248709873                      73
             285230516                      16

> select population, population % 100 from country_census;

POPULATION              POPULATION % 100
----------------------  ----------------------
              28846761                      61
              30007094                      94
             248709873                      73
             285230516                      16

The ABS function returns the absolute value of column.

This function returns the same datatype as the passed parameter.

ABS( numeric_expression )

Required. Any expression that returns a numeric-class datatype.

> select longitude, abs(longitude) from countries;

LONGITUDE                         ABS(LONGITUDE)
--------------------------------  --------------------------------
-176.199997                       176.199997 
-175.000000                       175.000000 
-172.330002                       172.330002 
-171.750000                       171.750000 
-170.699997                       170.699997 
-170.000000                       170.000000 
-169.860001                       169.860001