What do you accomplish by GROUP BY ... HAVING cl

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What do you accomplish by GROUP BY ... HAVING clause? ––

GROUP BY partitions the selected rows on the distinct values of the column on which you group by.
HAVING selects GROUPs which match the criteria specified

(Continued on next question...)

Other Job Interview Questions

• How would you print the output of an SQL statement from SPUFI? –
• How does DB2 store NULL physically?
• How does DB2 store NULL physically?
• Where do you specify them ?
• What are correlated subqueries?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• What is a precompiler?
• What is IMAGECOPY ? –
• What else is there in the PLAN apart from the access path? –
• What is COPY PENDING status?
• More...