select * from (select e.*,dense_rank() over(order by sal desc) r from emp e

i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table

Question Posted / obulesu

Answer Posted / obulesu

select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to start your 10g xe server from command line?

1074

How do I know if oracle is installed on windows?

932

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

4178

What is the difference between truncate & delete command?

1189

How to retrieve data from an explicit cursor?

1064

What is translate in oracle?

1101

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2320

Differentiate between pre-select and pre-query?

1115

How to return top 5 rows in oracle?

1068

What is the usage of analyze command in oracle?

1096

What is a named program unit?

1092

What is a oracle database?

1061

What are the parameters that we can pass through a stored procedure?

1069

How to call a stored function in oracle?

1021

How to change user password in oracle?

1034