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

Explain the difference between dbms and rdbms?

922

What is system catalog or catalog relation?

1066

what are the two integrity rules used in DBMS?

1100

What does rdbms stand for?

1056

What is dbms used for?

994

What is environment of openedge?

900

What are the two types of database?

984

what are the differences between an exclusive lock and a shared lock?

976

Mention the differences between unique key and primary key

935

What is advantages of progress actional?

904

What is called dbms?

1019

What is instance in dbms?

852

What is a php database?

865

What are stored procedures in a database?

923

Explain the main control blocks available in ims db?

885