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

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

Please Help Members By Posting Answers For Below Questions

What is transport network substrate (tns) in oracle?

1095

What is an oracle cursor variable?

1133

What is a snapshot log?

1051

What happens if recursive calls get out of control?

1139

What is the data type of dual table?

1066

What is the use of file param in imp command?

1217

How do I learn what codesets are available in oracle?

1080

How to update values in a table in oracle?

1079

What is columnar storage what is the advantage?

1121

Can you have more than one content canvas view attached with a window ?

2373

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

Give the advantages and disadvantages of clusters.

1096

How many data types are supported?

1140

How do I find my oracle client driver version?

1097

Explain alias?

1193