Query:

select job, max(sal) "max-sal", min(sal) "min-sal",MEDIAN(SAL) "msal" from emp group by job

Oracle:

PostgreSQL: there is no in built median function like oracle .
MySQL : does not have any inbuilt function