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

If I use netlib, will I find many other users to network with?

853

Can videos be stored in a database?

910

What is the concept of sub-query in terms of sql?

923

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

1845

How do you rename a database?

861

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

958

What are vdl and sdl?

1099

Explain what is meant by asymmetrical protocols?

1066

How to debug stored procedures?

918

State at least four kinds of indexing?

977

What do you mean by query evaluation engine?

925

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?

954

Explain the terms database and dbms. Also, mention the different types of dbms.

867

Explain a tp monitor?

918

What is the use of drop command?

1269