Answers for "Consider relation schema Employee(Eid ,Ename,Dept,Salary).Evaluate and write sql query to Display second highest salary from employee table"

how to get employee having maximum experience in mysql

select max(salary), dept_id from employee where salary not in(select max(salary) from employee) group by dept_id;

Posted by: Guest on November-02-2020

Code answers related to "Consider relation schema Employee(Eid ,Ename,Dept,Salary).Evaluate and write sql query to Display second highest salary from employee table"