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 n tier architecture in dbms?

992

How do you link a spreadsheet to a website?

979

What does clipper stand for?

1086

What is meant by database system?

965

Define and explain about progress?

991

Define scalar functions.

1037

Is access a database?

935

What are five types of database models?

950

What is 1nf?

1006

What integrity rules exist in the dbms?

1078

Can videos be stored in a database?

1008

What is data modelling concepts?

968

What are the main characteristics of database approach?

1109

What is advantage of dbms?

1065

What is 1nf in database?

1071