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

Should database table names be capitalized?

540

What is the importance of query in database?

479

What is the normal procedure followed by a java client to access the db?

431

does pl/sql support “overloading”? Explain

546

Define sub-query.

536

How to connect Silverlight application to database?

559

Which database is best for storing images?

481

What do you understand by proactive, retroactive and simultaneous update?

746

What is cold backup and hot backup (in case of oracle)?

462

What is in a database?

458

Is database a storage?

497

Describe a subquery.

559

What is data modelling concepts?

495

What is mean by dbms?

490

What are the advantages of database system?

470