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
What is the difference between pre-select and pre-query?
Explain about achiever in sql?
What happens to the current transaction if a ddl statement is executed?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is blob datatype?
What exactly do quotation marks around the table name do?
What is open database communication (odbc) in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What are the differences between blob and clob in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Is oracle an open source?
How many types of auditing in Oracle?
What are the types of trigger in oracle?
Explain database link?
What is a database table in oracle?