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
What is cost in sql execution plan?
How do I save the results of sql query in a file?
How much does sqlite cost?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Which command is used to delete a package?
What is rowid in sql?
What is trigger in sql? Explain
What is dbo in sql?
how to increment dates by 1 in mysql? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
What is the difference among union, minus and intersect?
What is cte sql?
What is trigger price?
What is string data type in sql?
Explain what is dbms?