select * from (select ename,sal,rank() over(order by sal desc) as ranks fro

how to find out second largest value in the table

Question Posted / kamala k n

8 Answers
9239 Views
I also Faced
E-Mail Answers

Answer Posted / kamala k n

select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what does a control file contain?

1034

How would you change old and new values in an insert, delete and update triggers?

953

What do you mean by a database transaction & what all tcl statements are available in oracle?

934

What is blob data type in oracle?

1049

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2134

How to assign a tablespace to a users in oracle?

992

Explain oracle’s server parameter file.

949

What is the difference between truncate & delete command?

1125

Explain enable novalidate constraint.

1035

How to install oracle odbc drivers?

1040

How does Oracle guarantee data integrity of data changes?

2333

What is private procedure oracle?

958

What is merge in oracle?

997

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

What is the difference between sharding and partitioning?

931