Find out the 3rd highest salary?

Answer Posted / dharmendra yadav

select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of triggers?

563


Which are the different types of indexes in sql?

563


how to select first 5 records from a table? : Sql dba

509


Can we insert delete data in view?

544


Does inner join return duplicate rows?

521






What is view? Can we update view

867


How does one use sql*loader to load images, sound clips and documents? : aql loader

674


How many types of normalization are there?

493


How many clustered indexes can you have?

535


What is sql lookup?

513


How many sql statements are used? Define them.

576


Does pl/sql support create command?

578


Explain the structure of pl/sql in brief.

621


Why do we need cursor in pl sql?

651


How to call a javascript function from pl sql?

565