Write a query to get 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...
Top Torry Harris Integration Solutions Associate Software Engineer Trainee interview questions & answers
Popular interview questions of Associate Software Engineer Trainee
>
Torry Harris Integration Solutions Associate Software Engineer Trainee 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
Contribute to help millions
Get AmbitionBox app