Infrrd Interview Questions: Sql query to find nth highest salary. What does limit and of

Asked inInfrrd,Java Back End Developer

Sql query to find nth highest salary. What does limit and offset do?

AnswerBot

2mo

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...

Top Infrrd Java Back End Developer interview questions & answers

Q1. Design a layered architecture for saving the user data to db. What all annotations to be used on each class and on funct...read more

View answer (1)

Q2. Which data structure to use to store data in the order of insertion and also have uniqueness?

View answer (1)

Q3. How to handle exception at controller level? Use of restcontrolleradvice

View answer (1)

Infrrd

Discover recent interview experiences

View all

Interview Tips & Stories

Ace your next interview with expert advice and inspiring stories

Explore community

Popular interview questions of Java Back End Developer

Q1. Design a layered architecture for saving the user data to db. Wha...read more

asked in

Infrrd

View answer (1)

Q2. Tell me about yourself. What roles and responsibilities you had i...read more

asked in

Coforge

Add answer

Q3. What is your expected Salay? Why we will select you in our compan...read more

asked in

Starcentauri Technologies

View answer (1)

Home

Interviews

Infrrd Interview Questions

Infrrd Java Back End Developer 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

65 Lakh+

Reviews

4 Lakh+

Interviews

4 Crore+

Salaries

1 Crore+

Users/Month

Contribute

Contribute to help millions

Reviews

Get AmbitionBox app