top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get Second Maximum Salary in an Organization?

0 votes
How to get Second Maximum Salary in an Organization?
posted Jul 16, 2014 by Amanpreet Kaur

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

3 Answers

+2 votes
SELECT TOP 1 Salary FROM Employee 
  Salary<(SELECT MAX(Salary)FROM Employee) 
Order BY 
  Salary DESC
answer Nov 17, 2014 by Manikandan J
0 votes

Lack of homework before asking question, looks like that you want to know the second highest number in SQL or MySQL.

Try something like this -

SELECT MAX( col )  FROM table
 WHERE col < ( SELECT MAX( col )  FROM table )
answer Jul 16, 2014 by Salil Agrawal
0 votes

You can try this.
"SELECT max(salary_obtained) FROM organization_tbl WHERE salary_obtained <( SELECT max(salary_obtained) FROM organization_tbl)".

answer Jul 17, 2014 by Karamjeet Singh
Similar Questions
+1 vote

How we can get nth max salary from Employee Table (EMP_ID, Salary)

Emp_id salary
1 1000
3 2000
4 16000
2 10000
7 19000
8 12000

e.g. for 3rd max salary, salary is 12000 so answer will be emp_id : 8