Which statement shows the maximum salary paid in each job category of each department?( )
Select dept_id,job_cat,max(salary) from employees where salary>max(salary);
Select dept_id,job_cat,max(salary) from employees group by dept_id,job_cat;
Select dept_id,job_cat,max(salary) from employees group by dept_id;
Select dept_id,job_cat,max(salary) from employees group by dept_id,job_cat,salary;
