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

What is the best database for big data?

646

Is database a data structure?

544

What is erd?

665

What's the difference between star and snow flake schema?

602

What do you mean by Checkbox ?

2002

What are the types of rdbms?

567

Explain what are triggers and rules?

586

What is big data in database?

548

What is sorting in dbms?

596

What is the purpose of using a model?

588

How do you set a primary key?

570

What is database normalization? Explain types of it.

581

Is it possible to declare or create a cursor for update of table? If no tell me why?

552

Define entity, entity type, and entity set.

602

What do database languages do?

601