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

How do you notify dbpak about stored procedure?

845

What is a key in dbms?

824

how to solve cardinality in dbms...many to many ralationships

1640

What is the definition of database management system?

975

What is pdo in database?

836

What is a 3nf table?

829

What is meant by system analysis?

995

Is filemaker pro a relational database?

986

Explain the term specialization.

796

How to export data from database and import into another?

860

What is bcnf?

961

Mention the differences between union and union all

855

How to schedule ssas database backup

942

What is third normal form?

867

What is use of foreign key?

808