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 to use windows user to connect to the server?

958

How to use "for" statements in oracle?

1040

Explain compound trigger in oracle?

999

Explain the types of exception?

1104

What is Undo Management Advisor in Oracle?

1062

Explain how you would restore a database using RMAN to Point in Time?

2116

what is Single Byte Overhead...?

2516

Explain the difference between sql and oracle?

1045

Explain the use of grant option in exp command.

1027

What is bulk collect in oracle?

973

How to call a stored function with parameters?

990

What is columnar storage what is the advantage?

1015

Explain the different normalization forms?

1033

What are the differences between char and varchar2 in oracle?

1107

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2457