ORACLE : MOD FUNCTION
SELECT ENAME, SAL , (MOD(SAL,2)) "MOD,2",(MOD(SAL,3)) "MOD,3",
(MOD(SAL,4))"MOD,4" ,(MOD(SAL,5))"MOD,5" FROM EMP WHERE ROWNUM < 7
PostgreSQL and MySQL
SELECT ENAME, SAL , (MOD(SAL,2))
"MOD,2",(MOD(SAL,3)) "MOD,3", (MOD(SAL,4))"MOD,4"
,(MOD(SAL,5))"MOD,5" FROM EMP LIMIT 6
|