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




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



More SQL Server Interview Questions

What is Trigger?

3 Answers   Misys,


Explain SELF JOIN ?

3 Answers   ADP,


what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  


How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  






Can XML be used to access data?

2 Answers  


find 2nd highest salary of person using cursor concept?

6 Answers   HCL,


how do u do Performance tunning ?

1 Answers   Satyam, Infodat Technologies,


CREATE a table from another table

2 Answers  


What is the difference between Drop and Truncate

20 Answers   IBM, GT Nexus,


Can you have a nested transaction?

4 Answers   HCL,


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  






Categories