please tell me the query to get details of the employee
having the second largest salary
Answers were Sorted based on User's Feedback
Answer / shivangi
Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)
Is This Answer Correct ? | 11 Yes | 1 No |
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 |
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 |
Answer / eswar
select max(salary) from emp
where salary<(select max(salary) from emp)
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
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 |
Answer / ss
select max(salary) from emp
where salary<(select max(salary) from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 |
What do you mean by data integrity?
What are rows and columns?
What is dbcc updateusage?
What are the 10 characteristics of data quality?
Where cross join is used?
How to delete duplicate rows?
What type of Index will get created after executing the above statement?
How do you Implement SSIS Packages in your Project?
Tell me what is the stuff and how does it differ from the replace function?
Characterize join and name diverse sorts of joins?
What is the New in SQL server 2008?
How can we check the sql server version?