What is the difference between GROUP BY and ORDER BY?
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. |
BY Best Interview Question ON 15 Jul 2020