DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS
My SQL statement SELECT AVG(SALARY) FROM EMP yie
More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?
Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.
(Continued on next question...)
Other Job Interview Questions