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 happens if the imported table already exists?

974

Explain the truncate in oracle?

914

How can you use check constraints for self referential integrity?

920

How to start your 10g xe server from command line?

1001

What is the usage of save points in oracle database?

909

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

919

State the difference between a primary key and foreign key?

889

How does Oracle guarantee data integrity of data changes?

2333

Is postgres faster than oracle?

972

What are group functions in oracle?

975

Can we store images in oracle database?

948

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1035

How to get the Installed Oracle Version Information ?

1075

How to convert csv to table in oracle?

924

Give the various exception types.

949