We can use an OLAP function select * from (select ename,sal,dense

find out the second highest salary?

Question Posted / mahesh

Answer Posted / mahesh

We can use an OLAP function
select * from
(select ename,sal,dense_rank() over(order by sal desc)
rankings from emp ) a
where a.rankings = 2;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How oracle handles dead locks?

1021

Differentiate between pre-select and pre-query?

1055

what is the difference between data migration and production migration.

2276

How to import one table back from a dump file?

972

What are operators in oracle?

1012

How can I introduce multiple conditions in like operator?

926

Is postgres faster than oracle?

972

What is Undo Management Advisor in Oracle?

1042

How to insert a record into a table?

1022

Explain the use of control file?

1061

What are the different types of trigger and explain its various uses and functions?

1010

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4115

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

What are the different windows events activated at runtime ?

2835

What is index-organized table in Oracle?

1021