SQL_Decimal_Round1
  • How to set a column name in PostygreSQL on the fly
  • SQL round function to manage decimal data.
SQL Script :

SELECT ename, sal, round(((sal * .15 + comm) /12),2)
FROM emp where job = 'SALESMAN'

EMP Table :

Oracle

PostgreSQL:


Compare Side by side