mysql_分组查询_基础

 

 　　1.查询每个工种的最高工资

select job_id,MAX(salary) from employees group by job_id