Hi guys, what's the difference between Order By and Group BY?. When must I use Group By?

Question

Hi guys, what's the difference between Order By and Group BY?. When must I use Group By?

Answer 1

ORDER BY alters the order in which items are returned. GROUP BY will aggregate records by the specified columns which allows you to perform aggregation functions on non-grouped columns (such as SUM, COUNT, AVG, etc). ORDER BY: sort the data in ascending or descending order.

https://techdifferences.com/difference-between-group-by-and-order-by.html

Please mention sql in your tags.

Answer 2

Thanks