Advanced Search

Return to Snippet

Revision: 71258
at January 30, 2017 06:48 by bbrumm
Initial Code 
SELECT MOD(16,3) as MOD_RESULT
FROM dual;

SELECT MOD(16.5,3) as MOD_RESULT
FROM dual;

SELECT MOD(16,3.5) as MOD_RESULT
FROM dual;

SELECT MOD(16.5,3.5) as MOD_RESULT
FROM dual;

SELECT MOD(16,0) as MOD_RESULT
FROM dual;

SELECT MOD('16','3') as MOD_RESULT
FROM dual;

SELECT MOD(47,15) as MOD_RESULT
FROM dual;



SELECT first_name, last_name, rn
FROM
(
  SELECT first_name, last_name, rownum as rn
  FROM customers
) c
WHERE MOD(rn, 2) = 0;
Initial URL 
http://www.databasestar.com/oracle-mod-function-with-examples/
Initial Description 
A few examples of the MOD function.
Initial Title 
Oracle MOD Function
Initial Tags 
sql, Oracle
Initial Language 
SQL