select a.* from(select dense_rank() over(order by sal)as new

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.

Question Posted / esakkiraja

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

Please Help Members By Posting Answers For Below Questions

What do you mean by merge in oracle and how can we merge two tables?

1000

What are the uses of synonyms?

1079

What is redo log?

1003

Write a syntax for update query in oracle?

967

What privilege is needed for a user to connect to oracle server?

938

What is rowid and rownum in oracle?

951

How to change program global area (pga) in oracle?

1031

How to define default values for formal parameters?

980

What is the maximum limit on the number of columns in a table?

1002

Explain the use of owner option in exp command.

989

What is the difference between substr & instr functions?

1118

What is oracle rownum?

883

What is oracle thin client?

970

Which are the five query types available in oracle?

894

What are operators in oracle?

1008