Objectives: SQL AS function:

Oracle

Select EMPNO,ENAME, sal , sal+( sal * 0.15) as inflation from emp WHERE ROWNUM < 5

MySQL and PostGreSQL

Select EMPNO,ENAME, sal , sal+( sal * 0.15) as inflation from emp limit 4

 

Oracle

Postgresql

MySQL