Answer / sagar dhande

select top 2(salary) from (select top 3 (salary) from
dbo.employee order by salary desc)
order by salary

Answer / praveen singh

select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)

Answer / satish

select max(sal) from emp e1 where 1< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

To make it generic if u want N'th highest salary;

select max(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal <= e2.sal)

And to get the N'th min sal :

select min(sal) from emp e1 where (N-1)< (select count(distinct sal) from emp e2 where e1.sal >= e2.sal)

Answer / veeresh kethari

with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc

Answer / vikas kant

---To get 2nd highest salary----

select Top 1 salary from Emp where marks in(select top 2
salary from Emp order by salary desc)

---To get 3rd highest salary----

select Top 1 salary from Emp where marks in(select top 3
salary from Emp order by salary desc)



Regards Vikas Kant

Answer / anil tiwari

select Top2(salery)from (select Top3 (salery) from tab1
order by salery DESC)order by salery.

Answer / dipti saxena

select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1

how you can list all the tables in a database?

0 Answers  

How sql server executes a statement with nested subqueries?

0 Answers  

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

How to execute function in stored procedure sql server?

0 Answers  

How do you debug a procedure in sql server?

0 Answers  

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

what is victor class

0 Answers  

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

Explain about local stored procedure?

0 Answers  

What protocol does sql server use?

0 Answers  

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers