+ 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?

13th Apr 2019, 7:36 PM
Tolulope Patrick
Tolulope Patrick - avatar
2 odpowiedzi
+ 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.
13th Apr 2019, 8:47 PM
sneeze
sneeze - avatar
+ 1
Thanks
13th Apr 2019, 8:53 PM
Tolulope Patrick
Tolulope Patrick - avatar