How good are you in SQL? Suppose we have an employee and a department table. What is the SQL querry to fetch the list of managers from an employee table who are getting 2nd highest salary from each department?

SQL query to fetch the list of managers with 2nd highest salary from each department

• Use a subquery to find the 2nd highest salary for each department

• Join the employee table with the subquery on depart...read more