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 a database schema in oracle?

1151

How to delete a column in an existing table in oracle?

1127

How do we create privileges in oracle?

1101

What is a read write transaction in oracle?

1132

How do we display rows from the table without duplicates?

1017

Explain the features of oracle?

1108

What are set operators?

1137

How to convert a date to char in oracle? Give one example.

1109

How to load excel data sheet to oracle database

1076

Give the advantages and disadvantages of clusters.

1096

How to start your 10g xe server?

1088

What is a database table in oracle?

1070

What are the different editions of oracle?

1179

What is a table index in oracle?

1186

Â How to use an oracle sequence generator in a mapping?

1131