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 create an oracle database?
List out the components of logical database structure of oracle database.
How to initialize variables with default values?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Can select statements be used on views in oracle?
How different is ms access and oracle?
How to sort the query output in oracle?
How do you bind variables in oracle?
Give the constructs of a package, function or a procedure.
Difference between cartesian join and cross join?
Can we use bind variables in oracle stored procedure?
why dont we assign not null constraint as table level constraint.
How to convert a string to a date in oracle database?