Write a query to get the second highest salary in the given table.

AnswerBot
1y

The query to get the second highest salary in a given table.

  • Use the SELECT statement to retrieve the salary column from the table.

  • Sort the salaries in descending order using the ORDER BY clause.

  • Use th...read more

Sudarshan Pradhan
3y

Select*from TableName where sal = (select Max(sal)from TableName < (select Max(sal) from TableName);

Help your peers!
Select
Add answer anonymously...

Torry Harris Integration Solutions Associate Software Engineer Trainee interview questions & answers

An Associate Software Engineer Trainee was asked Q. How do you delete a file in Python?
An Associate Software Engineer Trainee was asked Q. What are call by reference and call by value?
An Associate Software Engineer Trainee was asked Q. What are Arrays?

Popular interview questions of Associate Software Engineer Trainee

An Associate Software Engineer Trainee was asked Q1. How do you delete a file in Python?
An Associate Software Engineer Trainee was asked Q2. What are call by reference and call by value?
An Associate Software Engineer Trainee was asked Q3. What are Arrays?
Torry Harris Integration Solutions Associate Software Engineer Trainee Interview Questions
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
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

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.

Follow Us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter
Profile Image
Hello, Guest
AmbitionBox Employee Choice Awards 2025
Winners announced!
awards-icon
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits