SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 2 salary FROM employee ORDER BY salary DESC) a ORDER BY salary

The simplest way isselect max(sal) from Salary where sal in(select top 2 sal from Salary order by sal desc).

Select Salary from Employee A where 2=(select COUNT(*) from Employee B where B.Salary>=A.Salary)

Select max(salary) from (select top 2 distinct salary from table order by desc )

??? runman7942.com ?? ???? ???? ?? ????

Select Top 1 Salary From ( select top 2 salary from Table_name order by(salary) Desc )A Order By(Salary) Asc

Select Top 1 Salary From ( select top 2 salary from Table_name order by(salary) Desc )AOrder By(Salary) Asc

select * from table order by salary desc offset 2 rows fetch next 1 rows only

SELECT DISTINCT TOP 2E.Salary FROM Employee E EXCEPT SELECTMAX(Salary) FROM Employee ORDER BY E.Salary DESC

Select Amount from [PurchaseDetails] A where 2=(select COUNT(*) from [PurchaseDetails] B where B.Amount>=A.Amount) note :-PurchaseDetails is a table and Amount is a column more help contact:----- [email protected]

Select * from orders(NOLocK) order by Freight desc; WITH CTE as ( select ROW_NUMBER() Over (Order by Freight DESC) as RowNum,OrderID, CustomerID, Freight, EmployeeID from Orders) Select * FRom CTE where RowNum=2The above example is from northwind database

select max(salary) from employee where emp_id not in (select TOP(n) from employee order by salary desc )In your case n =1,as you want 2nd highest salary .To get 3 highest or so on just replace n acordingly.

SQL Queries in Oracle, select min(salary) from (select * from (select * from employee order by SALARY desc) where rownum < 3)SQL Queries in SQL Server, select min(SALARY) from (select top 2 * from employee) aSQL Queries in MySQL, select min(SALARY) from (select * from employee order by salary desc limit 2) afor more imp Sql query http://dotnet-munesh.blogspot.in/2013/12/important-sql-query.html