What is the difference between group by and orde

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

(Continued from previous question...)

What is the difference between group by and order by ?

Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.

(Continued on next question...)

Other Job Interview Questions

• When does the SQL statement gets executed when you use cursor in the application programming ?
• Which DB2 command is used to retireve environmental information?
• How do you do the EXPLAIN of a dynamic SQL statement ?
• What is the Manimum number of volumes that can be added to a STOGROUP?
• Can DASD types assigned to storage groups be intermixed ?
• Will precompile of an DB2 - COBOL program bomb, if DB2 is down?
• DB2 What is the difference between a package and a plan ?
• What is a DBRM, PLAN?
• How do you define a correlated name ?
• What is a DB2 access path?
• More...