write a query to Find the Maximun second value in table?
Answer Posted / kavita
select max(sal) from emp where sal not in (select max(sal)
from emp)
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What do you understand by aggregation and atomicity?
What is the role of database management system?
What are the ways to tune reporting services?
What are the benefits of database?
If you need to refresh a website page every time a record is updated in database, how would you do it?
What is correlated subquery in dbms?
What is denormalization and why would someone consider doing so?
How to migrate paradox, dbase or foxpro database to firebird?
Why are recursive relationships are bad? How do you resolve them?
How do you set up a database?
describe and contrast a trigger and a procedure.
What do you understand by query optimization?
What is openedge rdbms?
What do you know about Master Data & Transaction Info Package?
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........