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

What is translate in oracle?

1142

Explain overloading. Can functions be overloaded?

1047

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2103

Explain mutating triggers.

1088

How to export your connection information to a file?

1176

What is a initialization parameter file in oracle?

1083

How to connect to oracle using service name instead of sid?

1068

How to apply filtering criteria at group level in oracle?

1085

What are the different editions of oracle?

1179

How to insert a record into a table?

1121

When do you get a .pll extension in oracle? Explain its importance

1098

How to invoke the data pump import utility?

1228

Explain what are the uses of rollback segment?

1067

Explain the use of constraints option in exp command.

1082

11. Display the client number and name and the client number and name of the person who referred that client.

2390