SQL_Max1.htm
select job, max(sal) "max-sal" from emp group by job
Oracle:
PostgreSQL:
MySQL: