+1

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

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

4/13/2019 7:36:55 PM

Tolulope Patrick

2 Answers

New Answer

+2

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.

+1