select salary from(select rownum r,salary from details order by salary de

write a query to Find the Maximun second value in table?

Question Posted / smriti

Answer Posted / smriti

select salary from(select rownum r,salary from details
order by salary desc)where rownum<2 and salary<(select max
(Salary) from details)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an advantage of a database?

1001

What is variable dbms?

901

Describe a subquery.

999

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

872

Does netlib support windows 95?

908

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

983

Define database model.

1000

What do database languages do?

902

What are the properties of a database?

977

What are the differences between drop, truncate and delete commands?

1021

Explain the terms database and dbms?

879

What is atomicity in dbms?

905

What are the features of dbms?

904

What is the purpose of a database table?

899

Explain the Surrogate Key in DBMS.

905