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

how to check the 3rd max salary from an employee table?

Question Posted / akula

Answer Posted / akula

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is cursor. write example of it. What are the attributes of cursor.

748

How to use transactions efficiently : transact sql

550

What are pl sql procedures?

522

What are tuples in sql?

571

What is sql in java?

547

How can you tell the difference between an index and a view?

495

What is pl sql code?

593

Is sql better than access?

546

How can I change database name in sql?

533

What is execution plan in sql?

551

What is the purpose of primary key?

535

What is the difference between inner join and outer join?

534

Is sql difficult?

747

Mention what does the hierarchical profiler does?

564

What is having clause in sql?

529