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
What are different types of triggers?
Which are the different types of indexes in sql?
how to select first 5 records from a table? : Sql dba
Can we insert delete data in view?
Does inner join return duplicate rows?
What is view? Can we update view
How does one use sql*loader to load images, sound clips and documents? : aql loader
How many types of normalization are there?
How many clustered indexes can you have?
What is sql lookup?
How many sql statements are used? Define them.
Does pl/sql support create command?
Explain the structure of pl/sql in brief.
Why do we need cursor in pl sql?
How to call a javascript function from pl sql?