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 / sandeep

Answer Posted / sandeep

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the components of logical database structure in oracle database?

1086

What is a dynamic performance view in oracle?

989

How to define and use table alias names in oracle?

939

How to drop a tablespace?

1043

Why use resource manager in Oracle?

1102

What happens to the indexes if a table is recovered?

989

What is the usage of analyze command in oracle?

1093

How to establish administrator authentication to the server?

1035

What is flashback in Oracle?

1015

Explain about the analyze command in oracle?

1048

How to convert characters to times in oracle?

1021

What to do if the binary spfile is wrong for the default instance?

1065

Explain joins in oracle?

1033

What is the disadvantage of User defind function?

2288

How to create an initialization parameter file?

1047