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

Who developed sql?

0 Answers  

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

What is mutating table?

11 Answers   Saama Tech,

How do you write an inner join query?

0 Answers  

how to create temparary sequence

2 Answers   TCS,

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

What are different types of indexes?

0 Answers  

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

how to convert dates to character strings? : Sql dba

0 Answers  

How can I delete duplicate rows?

0 Answers  

Can a foreign key have a different name?

0 Answers