Answer Posted / lingareddy
select top 1 salary from (select distinct top 5 salary from emp order by salary desc ) a order by salary asc
if u have any doubts in SQL kindly reach with me,
Thanks & Regards,
Lingareddy.S
sabbasani.reddy1@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to view the tablespaces in the current database?
How to create a stored function in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Will you be able to store pictures in the database?
What do you know about normalization? Explain in detail?
What is an oracle user account?
Can we store pictures in the database and if so, how it can be done?
How does one get the view definition of fixed views/tables?
How to export your own schema?
How do I manually create a database in oracle?
What is the usage of merge statement?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to create a server parameter file?
What is a data lock in oracle?
What is the difference between substr and instr?