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

How to convert characters to dates in oracle?

1091

What is where clause in oracle?

1024

What are the limitations oracle database 10g xe?

1042

What are the differences between char and varchar2 in oracle?

1166

Explain an exception?

991

Why do you use stored procedures and state some of its disadvantages?

1026

What are the different pseudo commands? Explain in general?

1073

Explain the features of oracle?

1038

What is Library Cache in Oracle?

1142

Why is oracle so popular?

990

What is an oracle cursor variable?

1073

How to use subqueries with the exists operator in oracle?

1024

How to define a cusotmer as a supplier in ORACLE R12

2228

Why packages are used in oracle?

1066

what is the difference between functional dependecy and multilevel dependency?

2458