please tell me the query to get details of the employee having the second larg

Categories >> Software >> Databases >> SQL Server
Suggest New Category

please tell me the query to get details of the employee
having the second largest salary

Question Posted / srikanth

11 Answers
14877 Views
247Customer, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

please tell me the query to get details of the employee having the second largest salary..

Answer / shivangi

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

Is This Answer Correct ?

11 Yes

1 No

please tell me the query to get details of the employee having the second largest salary..

Answer / sushil

select min(a.standardcost) from
(
select distinct top 2 StandardCost
from Production.ProductCostHistory
order by standardcost desc
)a

Is This Answer Correct ?

5 Yes

1 No

please tell me the query to get details of the employee having the second largest salary..

Answer / krishna mohan thamisetty

SELECT * FROM Emp e1
WHERE 2 = (SELECT COUNT(*) FROM Emp e2 WHERE e1.Salary <=
e2.Salary)

Is This Answer Correct ?

6 Yes

3 No

please tell me the query to get details of the employee having the second largest salary..

Answer / eswar

select max(salary) from emp
where salary<(select max(salary) from emp)

Is This Answer Correct ?

4 Yes

1 No

please tell me the query to get details of the employee having the second largest salary..

Answer / devendra dwivedi

Select * from EmpTbl Where Salary = (Select Max(Salary) from
EmpTbl Where Salary < (Select Max(Salary) from EmpTbl)

Is This Answer Correct ?

3 Yes

1 No

please tell me the query to get details of the employee having the second largest salary..

Answer / rathi

If we had a table named Employee which had a column named
Salary and we had to find the second highest Salary in the
Employee table, the query for the same would be:

SELECT TOP 1 Salary FROM (SELECT TOP 2 Salary FROM Employee
ORDER BY Salary DESC) AS E ORDER BY Salary ASC

The subquery or the inner query would return the top 2 rows
in descending Salary order which would be:
5000
4000
The outer query would then select the top 1 row from the
subquery results in ascending Salary order which would be:
4000

Is This Answer Correct ?

2 Yes

0 No

please tell me the query to get details of the employee having the second largest salary..

Answer / ss

select max(salary) from emp
where salary<(select max(salary) from emp)

Is This Answer Correct ?

1 Yes

0 No

please tell me the query to get details of the employee having the second largest salary..

Answer / roshan

select employeeid, employeeName ,Salary from table1 where
Salary =(select min(a.Salary) from table1 inner join
(select top 2 Salary from table1
order by Salary desc) a on table1.Salary = a.Salary)

if we change the top value we will get the n'th largest
salary

Is This Answer Correct ?

0 Yes

0 No

please tell me the query to get details of the employee having the second largest salary..

Answer / ram

SELECT TOP 1 ESAL
FROM
(
SELECT DISTINCT TOP 2 ESAL
FROM EMPLOYEE
ORDER BY ESAL DESC
)ABC
ORDER BY ESAL ASC

Is This Answer Correct ?

0 Yes

0 No

please tell me the query to get details of the employee having the second largest salary..

Answer / ajay sara

Select Min(Salary) From (Select Top N * From Table_Name
Order by Salary Desc)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer