Answer / yadunandan

select max(sal) from emp where sal<(select max(sal) from
emp)

Answer / anilchandu

Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)


where x,y are alias names.

If you want 3rd heighest salary then just replace 2 by 3

Answer / manjeet

select max(sal) from emp where sal not in (select max(sal)
from emp)

Answer / prabhudatta barick

--IN ORDER TO FIND THE NTH HIGHEST SALARY,
--WE JUST FIND THE SALARY THAT HAS EXACTLY N-1 SALARIES
GREATER THAN ITSELF---

--This is correlated subquery--
select empno,
ename,
sal
from scott.emp e
where &n-1=(select count(distinct b.sal) from scott.emp b
where b.sal>e.sal);

To get second highest salary put n value 2.

Answer / rakhi

SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;

Answer / amit bhagat

select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

Indexes in oracle ?

3 Answers   Keane India Ltd, L&T,

How to define an anonymous block?

0 Answers  

can u plz provide me oca sql dumps please i need them

0 Answers  

how many types of index?

2 Answers   Cap Gemini, TCS,

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,

How to connect the oracle server as sysdba?

0 Answers  

What do you mean by a deadlock?

0 Answers  

How to estimate disk space needed for an export job?

0 Answers  

How can we find out the current date and time in oracle?

0 Answers  

what is the difference between dbms and rdbms?

3 Answers   Oracle,