What is the difference between GROUP BY and ORDER BY in DB2?

In DB2, GROUP BY and ORDER BY are two SQL clauses that are used for different purposes:

• GROUP BY: GROUP BY is used to group rows that have the same values into summary rows. It is typically used with aggregate functions like SUM, AVG, COUNT, etc. The grouped rows are then processed as a single unit.
• ORDER BY: ORDER BY is used to sort the result set based on one or more columns. It does not group rows, but simply orders them in either ascending or descending order based on the specified columns.

In summary, GROUP BY is used for creating summary rows based on common values, while ORDER BY is used for sorting the result set based on specified columns.