find out the third highest salary?

Answer Posted / akshita

select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3

Is This Answer Correct ?    43 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle rowcount?

571


What are the logical operations?

673


How to start your 10g xe server from command line?

544


Explain what are the uses of rollback segment?

580


Explain the use of grant option in exp command.

586






How to define a sub function?

662


Is truncate autocommit in oracle?

633


What is using clause and give example?

580


How to connect ms access to oracle servers?

548


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1782


what is the dual table in oracle?

550


What do you mean by merge in oracle?

590


What is a directory object?

589


What is blob data type in oracle?

555


Explain an index?

656