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?
AnswerBot
1mo
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
Help your peers!
Add answer anonymously...
Top EagleDrift Technologies Senior Software Engineer interview questions & answers
Popular interview questions of Senior Software Engineer
Top HR questions asked in EagleDrift Technologies Senior Software Engineer
>
EagleDrift Technologies Senior Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
