Find out the 3rd highest salary?
Answer Posted / durgashivashankar
select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you load data into multiple tables at once? : aql loader
What is hibernate and its relation to sql?
What are the three forms of normalization?
Which is faster count (*) or count 1?
What does over partition by mean in sql?
What is the use of partition by in sql?
What is the difference between python and sql?
What are the different ways to optimize a sql query?
what is the difference between a web-garden and a web-farm? : Sql dba
define join and explain different type of joins? : Sql dba
What is a pl/sql block?
Is primary key a clustered index?
Does sql profiler affect performance?
What are commit, rollback, and savepoint?
Is primary key always clustered index?