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 THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2212

What is Undo Management Advisor in Oracle?

1107

What is the simplest tool to run commands on oracle servers?

1013

What is not equal to in oracle?

1006

Explain how are indexes update?

1071

How to create a new user account in oracle?

1025

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

2290

Explain the use of owner option in exp command.

1052

Where do you use decode and case statements?

1002

What is a package in oracle?

1111

Calculate difference between 2 date / times in oracle sql?

1045

What are temporal data types in oracle?

1128

What is user managed backup in Oracle?

1149

What is a private synonym?

1593

How to get maxsal , minsal, ename department wise in single query

1555