1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / esakkiraja
select a.* from(select dense_rank() over(order by sal)as
new_rank from emp) a where new_rank=2
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the usage of save points in oracle database?
How to create a table index?
How to create an oracle testing table?
Why does for update in oracle 8 cause an ora-01002 error?
How to experiment a data lock in oracle?
What is a system tablespace and when it is created?
What are the limitations oracle database 10g xe?
Explain the use of show option in imp command.
Explain what are synonyms used for?
How to name query output columns in oracle?
How to use fetch statement in a loop?
What is the best way to do multi-row insert in oracle?
How to delete all rows a table in oracle?
What are the different types of synonyms?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?