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
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
Define view, sequence and index in DBMS.
Write about Transaction Management in Oracle 9i?
How can you get the alternate records from the table in the sql?
What is the best database software?
What are the examples of database?
What is artificial key?
What is the purpose of database management system?
Define entity set.
How to determine who is and change the owner of database?
What is difference between database and schema?
What is database optimization?
What is a candidate key in dbms?
What is tuple in rdbms?
What is database Configuration assistant ?