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 convert character types to numeric types?
What are the different types of record groups in oracle? Explain each of them
How to create a stored program unit?
What is difference between sid and service name in oracle?
Explain the truncate in oracle?
How to start a new transaction in oracle?
How many file formats are supported to export data?
Describe an oracle table?
How to best split csv strings in oracle 9i?
What privilege is needed for a user to delete rows from tables in another schema?
What is the usage of synonyms?
How to connect to oracle using service name instead of sid?
How can I introduce multiple conditions in like operator?
What is Virtual Private Database in Oracle?
How to shutdown your 10g xe server from command line?
