select sal from (selec sal, row_number () over (order by sal desc nulls

write a query to Find the Maximun second value in table?

Question Posted / kd

Answer Posted / kd

select sal
from
(selec sal, row_number () over (order by sal desc nulls
last) as rnk
where rnk = 2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Give us a non-computer example of preemptive and non-preemptive scheduling?

924

What is 3 level architecture dbms?

990

What is procedure in dbms?

891

Explain the difference between dbms and rdbms?

944

What are the different types of languages that are available in the dbms?

1031

What are the types of distributed database?

907

What is third normal form?

920

What are the uses of database management system?

1001

How do you exit a database?

902

Explain what are the two types of oltp?

1028

What are the database skills?

963

How to migrate paradox, dbase or foxpro database to firebird?

1028

Is it possible to break netlibs encryption?

946

What is cold backup, hot backup, warm backup recovery?

831

What are the steps in creating a database?

925