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 is the difference between I and G in Oracle?

1099

How does oracle handle read consistency?

1099

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

How to omit columns with default values in insert statement in oracle?

1049

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2355

What are privileges and grants?

1067

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1913

How to loop through data rows in the implicit cursor?

1078

What is procedure overloading in oracle?

1061

What are the ways tablespaces can be managed and how do they differ?

2368

What is the difference between translate and replace in oracle?

1167

What is a package ? What are the advantages of package ?

1093

How to download oracle database 10g xe?

1018

what are actual and formal parameters?

1104

What is an oracle cursor variable?

1081