Write a query to find the nth highest salary for every department
AnswerBot
1y
Query to find the nth highest salary for every department
Use the RANK() function to rank salaries within each department
Filter the results to only include the nth highest salary for each department
Use...read more
Help your peers!
Add answer anonymously...
Top IBM Advisory Technical Services Specialist interview questions & answers
Top HR questions asked in IBM Advisory Technical Services Specialist
>
IBM Advisory Technical Services Specialist 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