Asked in Infrrd
Sql query to find nth highest salary. What does limit and offset do?
AnswerBot
10mo
SQL query to find nth highest salary using LIMIT and OFFSET.
Use ORDER BY salary DESC to sort salaries in descending order.
Use LIMIT 1 OFFSET n-1 to get the nth highest salary.
For example, SELECT salar...read more
Help your peers!
Add answer anonymously...
Interview Questions Asked to Java Back End Developer at Other Companies
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
