To find the second largest salary amount from employee table

select max(salary) from employees
where pin < (select max(salary) from employees)

To find Nth largest salary (not only second largest salary) the query is :

select sal from emp e where &n (select count(*) from emp

where e.sal< sal)

Select * from EMP E1 where (N-1) (Select count(salary) from EMP E2 where salary.E2>salary.E1)

hi feroz

You answer is corect. Thanks!!!

Pravin

To Select Second highest Salary from Emp Table:

Query: Select Max(Distinct(a.sal)) from emp a where 2 select (count (distinct(sal)) from emp b where a.sal<b.sal )

For any question of this type .. just follow the simple methodology called TOP N ANALYSIS.

For the 3rd highest salary employee

Select emp_name rownum

From (select emp_name from emp Order by sal DESC)

where rownum 3.

For further clarification just test the similar type of queries with this methodology.

Feroz's Query is correct. It correctly finds the 2nd largest number in a table.

Can any one plz give the same for nth highest number?

Thanks

Sanjeev Kumar Jha