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

find the third highest salary?

Question Posted / rohit kumar

Answer Posted / rohit kumar

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

Is This Answer Correct ?

17 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How insert into statements in sql?

1011

How is indexing done in search engines?

930

What are different types of keys?

1020

Can we enter data in a table in design view?

913

When to use inner join and left join?

906

Explain mutating table error.

1132

Which certification is best for sql?

940

Explain the components of sql?

995

What is the unique index?

1005

What is identity column in sql server?

988

Are sql connections encrypted?

961

How do I find duplicates in the same column?

1000

How do I audit the sql sent to the server?

958

How does sql store data?

867

What is the difference between null value, zero, and blank space?

1139