MOD

 

The function MOD returns the remainder of the division from 2 integer values.

SQL Syntax 1:
 
   MOD( dividend, divisor )
Dividend:
 
  Any INT expression.
Divisor:
 
  Any INT expression.
Escape Syntax:
 
  {fn MOD( dividend, divisor )}
Return Type:
 
  INT
     

Examples:

  • SELECT MOD(20,3), {fn mod(15,3)}

    Returns:2, 0

see also:
SQL Numeric Functions


100% pure Java DBMS
Mirror Site