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 the full form of rdbms?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
Define denormalization.
What are the main components of a database in healthcare?
What is dba in dbms?
What is database management used for?
What do you mean by entity type?
Why do we need database?
What is raid controller technology?
Is it possible to declare or create a cursor for update of table? If yes tell me how?
What is a 3nf table?
What is the type of image in database?
How big is google's database?
What's the difference between file and database? Can files qualify as a database?
What is sorting in dbms?