Answer Posted / bhaskar reddy
the aggrigate function are
min, max, avg, sum, count
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
can all users have the privilage to use the sql statement select * (dml)?
What are the prerogatives?
What is the maximum size of a char data type in db2?
What is node in db2?
How do I copy a table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the difference between spufi and qmf?
Explain in detail about buffer manager and its functionalities?
What is dclgen in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the max length of sqlca?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the use of db2 optimizer?
What is drop table?