What is the difference between GROUP BY and ORDER BY?

Answer»

GROUP BY	ORDER BY
Used for aggregating data in a database.	Used for sorting data in a database.
Used to change the form and composition of Data	Used to change the display mode of data.
Attributes within GROUP BY are similar	Attributes within ORDER BY are not similar.
Its FUNCTION is to calculate aggregates.	Its function is to SORT and arrange in columns.

Discussion