Find out the 3rd highest salary?
Answer Posted / sachin
select * from ( select * from (select * from emp order by
sal desc)
where rownum<=3
order by rownum desc)
where rownum=1
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How many primary keys can a table have?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is the main reason behind using an index?
What sql does db2 use?
How to download oracle sql developer?
What is the syntax and use of the coalesce function?
What does select top 1 do in sql?
What is data modelling in sql?
Explain the difference between drop and truncate commands in sql?
What is a constraint?
How many times can we commit in a loop?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is a Mapplet?
What are conditional predicates?
How to run sql statements with oracle sql developer?