How do you calculate 3rd highest salary in each company?
Anonymous
1y
Use a partition function to rank salaries in descending order. Partition by Company name. Put the entire query in a subquery and in the main query add a condition to filter where rank = 3
Help your peers!
Add answer anonymously...
Popular interview questions of Data Scientist
Top HR questions asked in Exl India Data Scientist
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