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

What do you understand by a database object? Can you list a few of them?

1063

Does facebook use oracle?

1084

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

How to see free space of each tablespace?

1081

How to build data dictionary view an new database?

1052

Explain the blob datatype?

1122

How to delete a column in an existing table?

1130

Can a parameter be passed to a cursor?

1180

Explain the use of analyse option in exp command.

1194

What happens if you set the sga too low in oracle?

1223

what happened to the global index when I truncate the data in one of the partition?

2066

How to call a sub procedure?

1147

Is oracle an operator?

982

How would you begin to troubleshoot an ORA-3113 error?

2125

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414