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
6mo
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...
EagleDrift Technologies Senior Software Engineer interview questions & answers
A Senior Software Engineer was asked 6mo agoQ. What components have you worked with in Ab Initio?
A Senior Software Engineer was asked 6mo agoQ. What is the difference between a watcher and a breakpoint?
A Senior Software Engineer was asked 6mo agoQ. What is the difference between Rollup and Scan?
Popular interview questions of Senior Software Engineer
A Senior Software Engineer was asked 6mo agoQ1. What components have you worked with in Ab Initio?
A Senior Software Engineer was asked 6mo agoQ2. What is the difference between a watcher and a breakpoint?
A Senior Software Engineer was asked 6mo agoQ3. What is the difference between Rollup and Scan?
>
EagleDrift Technologies Senior Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
