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
Does mysql support pl sql?
What are the types of variable use in pl sql?
How many columns should be in an index?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
i have some prob lem to tell me about my self in interview first round ...
What is difference sql and mysql?
Can we insert data in view?
When you have to use a default "rollback to" savepoint of plvlog?
What is before and after trigger?
discuss about myisam index statistics collection. : Sql dba
How do I delete a trigger?
What is cte sql?
How do I know if I have sql express or standard?
what are date and time data types in mysql? : Sql dba
Explain the working of primary key?