Answer / anu

select *
FROM (select emp1.* ,rownum rnum
     from ( select *  from emp order by sal_amount desc ) emp1
     where rownum<=3) 
where rnum >=3   

Answer / farrukh shaikh

select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3

Answer / meher

SELECT SAL FROM EMP A WHERE &N= (SELECT COUNT(DISTINCT) SAL
FROM EMP B WHERE A.SAL<B.SAL)

--Pass the value for N as 2 to get 3rd highest salary.
--pass 0 for highest sal,1 for 2nd highest,2 for 3rd
highest and so on....

Answer / pradeep

select * from emp where sal in(select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3);

Answer / gautam

select * from (
SELECT ROWNUM as RANK, ename, sal
FROM (SELECT ename,sal FROM emp ORDER BY sal DESC)
WHERE ROWNUM <= 3)
where rank=3

Answer / deepak kumar

SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1

Answer / yankee

select * from (select * from <table_name> order by salary
desc)where rownum<4

---this way u can get the record of the top 3 salaries and
easily filter out the 3rd positioned salary from there.

Answer / mousumi dalai

select min(sal) from emp where sal in
( select sal from
(select sal from emp order by sal desc)
where rownum<=3)

Answer / anil pednekar

select * from (select sal from table1 group by sal ) where
row num=3

Answer / satish prajapati

select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3

what are the different types of joins?

4 Answers   Choice Solutions,

Why do we use triggers?

0 Answers  

explain access control lists. : Sql dba

0 Answers  

What is ttitle and btitle?

0 Answers  

What is record data type?

0 Answers  

Why stored procedures are faster than query?

0 Answers  

Why we use joins in sql?

0 Answers  

Do you understand the meaning of exception handling?

3 Answers  

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

What is trigger explain with example?

0 Answers  

What is bind reference and how can it be created?

0 Answers  

What is intersect?

1 Answers