select top 1 salary from(select distinct top 2 salary from emps order by Salary)a order by a.salary desc

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

SELECT SALARY FROM(SELECT SALARY, ROW_NUMBER() OVER(ORDER BY SALARY ASC) AS ROWNUM FROM SALARYTABLE ) SAl WHERE ROWNUM=2

select MAX(sal) from emp where sal not in(select MAX(sal) from Emp)

SELECT MAX(SALARY) FROM (SELECT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY ASC) Res

Select Top 1 Salary as '2nd Minimum Salary' from (Select distinct top 2 salary from TableName order by Salary desc) a order by Salary asc

Select Top 1 Salary as '2nd Minimum Salary' from (Select distinct top 2 salary from TableName order by Salary desc) a order by Salary asc

Select Top 1 Salary as '2nd Minimum Salary' from (Select distinct top 2 salary from TableName order by Salary desc) a order by Salary asc

Select max(sal) from salary where sal < (Select top 2 max(sal) from salary order by sal desc)

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

select MIN(Salary) from Employee WHERE Salary <> (select MIN(Salary) from Employee )

Select top 1 * from( select top 2 * from employees order by salary desc)t

Select TOP 1 Salary as '2rd Lowest Salary' from (SELECT DISTINCT TOP 2 Salary from Employee ORDER BY Salary ASC) a ORDER BY Salary DESC

SELECT MAX(SALARY) FROM (SELECT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY ASC) Res

select TOP 1 salary from(select distinct TOP 2 salary from employee order by salary asc) a order by salary desc

select *from (SELECT DENSE_RANK() over (order by total_price desc) as SNO , total_price FROM Sales) as dr where SNO = 2

Select TOP 1 Salary as '2rd Highest Salary' from (SELECT DISTINCT TOP 2 Salary from Employee ORDER BY Salary ASC) a ORDER BY Salary DESC

Select Top 1 EmployeeName,Salary from (Select Top 2 EmployeeName,Salary From TblEmployee order by Salary desc) TblTempEmployee order by Salary desc

Select max(salary ) from table1 where salary not in (Select max(salary) from table1)

SELECT MIN(No) FROM dbo.tbltemp2 WHERE No NOT IN ( SELECT DISTINCT TOP 1NoFROM dbo.tbltemp2ORDER BY No )

SQL Server 2008 R2 or earlier SELECT SALARY FROM(SELECT SALARY, ROW_NUMBER() OVER(ORDER BY SALARY ASC) AS ROWNUM FROM SALARYTABLE) SAl WHERE ROWNUM=2SQL Server 2012 or Higher Select Salary From Table Order By Salary Offset 2 Rows Fetch Next 1 Rows Only

select min(salary) from employee where salary<>(select min(salary) from employee);

select min(salary) from employee where salary<>(select min(salary) from employee);

http://dotnet-munesh.blogspot.in/2013/12/important-sql-query.html

SQL Queries in SQL Server, select MAX(SALARY) from (select top 2 * from employee) a

SELECT MIN(Salary) FROM Employee WHERE Salary NOT IN(SELECT MIN(Salary) FROM Employee)SELECT MAX(SALARY) FROM (SELECT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY ASC)

select min(amount)from Payment where Amount not in (select distinct top 1 amount from Payment order by amount ASC ) for max select max(amount)from Payment where Amount not in (select distinct top 1 amount from Payment order by amount desc )

select Sal from Emp e1 where 1=(select Count(e2.sal) from Emp e2where e2.sal>e1.sal)

As of SQL Server 2012 you can use: SELECT Salary FROM Employees GROUP BY Salary ORDER BY Salary OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY

select MIN(sal) from emp where sal not in(select MIN(sal) from emp) for min sal

select MAX(sal) from emp where sal not in(select MAX(sal) from Emp)