write a query to Find the Maximun second value in table?
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 |
Post New Answer View All Answers
What is oracle block? Can two oracle blocks have the same address?
What are the two major subsystems of system r?
What are the two types of database?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is dbms and its advantages?
What is the importance of database in an organization?
What are the applications of rdbms?
What is a database in layman terms?
What is 'cross join'? Or what is cartesian product?
Enlist various types of interactions created by dbms?
What are the advantages and disadvantages of views in the database?
What is string in database?
What is distributed queries?
Explain the functionality of dml compiler.
When does checkpoint occur in dbms?