Posted By

bbrumm on 01/30/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 01/30/17 06:48am

Statistics

Viewed 620 times

Favorited by 0 user(s)

Related snippets

Oracle MOD Function

/ Published in: SQL

A few examples of the MOD function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;