select min(sal) from (Select rownum,sal FROM emp> Order by sal desc)

Find out the 3rd highest salary?

Question Posted / durgashivashankar

51 Answers
73552 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

Answer Posted / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why is sql*loader direct path so fast?

1094

What is cartesian join in sql?

1099

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3991

Is join and inner join the same?

991

What is sql integrity?

1138

What is pl sql package?

1025

What is the difference between having clause and where clause?

1048

Can a foreign key be a duplicate?

898

How to add, remove, modify users using sql?

1024

What operating systems are supported by oracle sql developer?

939

What are types of joins?

950

What is java sql package?

1076

How are functions and procedures called in PL/SQL?

1197

Is it possible to read/write files to-and-from PL/SQL?

1085

Explain what is a database?

1078