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


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

