SQL :DIVISION AND DIVISIBLE
SELECT ENAME, SAL , SAL/2, ROUND(SAL/3,2)"SAL/3",
ROUND(SAL/4,2) "SAL/4", ROUND(SAL/5,2) "SAL/5", ROUND(SAL/6,2)
"SAL/6" , ROUND(SAL/800, 2) FROM EMP
POSTGRESQL AND MTSQL
SELECT ENAME, SAL , round(SAL/2) "SAL/2",
ROUND(SAL/3,2)"SAL/3", ROUND(SAL/4,2) "SAL/4", ROUND(SAL/5,2)
"SAL/5", ROUND(SAL/6,2) "SAL/6" , ROUND(SAL/800, 2) FROM EMP limit 6
|