My sql statement select avg(salary) from emp yields inaccurate results. Why?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is a host variable?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is check constraint in db2?
where will u check for sqlcode ?
what is load and unload in db2
What are the benefits of using the db2 database?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
How can you split a table in to exactly half?