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

Explain an index segment?

1071

What is a subquery?

1076

What is an external table?

982

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2312

How to use existing values in update statements using oracle?

1032

Explain coalesce function?

1144

How do I connect to oracle database?

1056

What is literal?

971

What do you mean by redo log file mirroring?

996

How to use regular expression in pattern match conditions in oracle?

998

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1848

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

1059

What is oracle host variable?

1014

What are the different editions of oracle?

1073

Is oracle a relational database?

892