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

Define database lock and its types.

1052

What is 2nf in database?

1081

Mention the different languages present in dbms

1008

What do you mean by conflict serializability in dbms?

970

What is the first step in creating a database?

933

How do we select distinct values from a table?

970

In DBMS, what are the two integrity rules used?

995

What is primary key in database?

966

RDBMS file system can be defined as

1075

What are the 5 databases?

906

What is 3 level architecture dbms?

1056

What is a distributed database system?

995

What is sonicmq?

955

Describe the difference between homogeneous and heterogeneous distributed database.

1134

Mention few case manipulation functions in sql

1043