+ 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?
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.
+ 1
Thanks