HOME
GROUP BY vs ORDER BY Lately, when I was designing a query for a website, I was wondering about the exact difference between group by and order by in a query. The easiest explanation is that order by is doing the sorting of a table and the group by clause is used for aggregation of a field. Ok, this is for the theory, let's see an example: The following table contains the items bought by several people last week: cust_id item total price 1 balloon 1 2 apple 3 1 apple 4 1 pillow 25 3 plastic bag 1 Order By Let's see the following query: SELECT * FROM shopping ORDER BY total_price The output will be: cust_id item total price 1 balloon 1 3 plastic bag 1 2 apple 3 1 apple 4 1 pillow 25 as you can see the fiels have been ordered by the price. The default order is...