SQL_Max_Min1.htm

Query:

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

Oracle:

PostgreSQL:

 
MySQL