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 |
when inserting to a table how many rows will be effected using triggers
What do you understand by recursive stored procedures?
How to return the top 5 rows from a select query in ms sql server?
How would we use distinct statement? What is its use?
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
What is the purpose of sql profiler in sql server? : sql server database administration
What do you mean by a dependent functionality in a build?
Explain what are the database objects? : SQL Server Architecture
What is the use of RDBMS?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
What is query cost in sql server?
Explain Geography datatype in SQL Server