Objective: Column Specific Functions
  • AVG function compared between Oracle 11.2g and PostgreSQL
Testing Query Script :

SELECT AVG(SAL) FROM emp where job = 'SALESMAN'

 
Oracle

 
PostgreSQL


Note differences : Oracle :