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 is indexing explain it with an example?
Can you explain the role of each service?
i need some interview questions on sql server developer plz any onee send some links.
How do I find query history in sql server?
What are different replication agents and what's their purpose? : sql server replication
What is spid in sql server profiler?
Explain log shipping and mention its advantages.
Explain an automatic checkpoint
What are the advantages of having an index on the sql server?
Explain index in sql server?
What is a trigger in sql server?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,