SQL_REMAINDER1.htm
ORACLE: REMAINDER ( shows a number which either overflow or under how many digits off or less form the nearest divisible number

ORACLE

SELECT ENAME, SAL , (REMAINDER(SAL,2)) "RE,2",(REMAINDER(SAL,3)) "RE ,3", (REMAINDER(SAL,10))"RE,10" FROM EMP WHERE ROWNUM <7

POSTGRESQL AND MYSQL : Not available in these

 

ORFACLE:

POSTGRESQL