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's the difference between clustered and non-clustered indexes?
What are the key constraints in dbms?
does pl/sql support “overloading”? Explain
What are service-specific middleware?
How to change database dialect?
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
What is difference between database and website?
What are the types of database?
What are the features of openedge features?
Explain a tp monitor?
how to restore particular schema from rman full backup?
what is scan listener.
What is drivermanager getconnection?
What is view dbms?