find out the third highest salary?
Answer Posted / rajeevgeu
select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are actual and formal parameters?
How to create a server parameter file?
Explain what are the uses of rollback segment?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What would you do with an in-doubt distributed transaction?
State and explain about oracle instance?
Does oracle charge for java?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
 How to use an oracle sequence generator in a mapping?
How a database is related to tablespaces?
What is bind variable in oracle 11g?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What to do if the binary spfile is wrong for the default instance?
Can we save images in a database and if yes, how?
How do you find current date and time in oracle?