Interested to Buy Any Domain ? << Click Here >> for more details...
My sql statement select avg(salary) from emp yields inaccurate results. Why?
- 0 Answers
- 1102 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What do you need to do before you do EXPLAIN ?
How do you do the EXPLAIN of a dynamic SQL statement?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is the physical storage length of date data type?
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?
What are db2 objects?
Where besides the DB2 catalog is database object information stored by DB2?
What is db2 bind?
Are view updateable?
What is iseries database?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
COBOL 
