1. Order By :
Order by keyword sort the result-set either in ascending or in descending order. This clause sorts the result-set in ascending order by default. In order to sort the result-set in descending order DESC keyword is used.
Order By Syntax –
SELECT column_1, column_2, column_3........... FROM Table_Name ORDER BY column_1, column_2, column_3....... ASC|DESC; Table_Name: Name of the table. ASC: keyword for ascending order DESC: keyword for descending order
2. Group By :
Group by statement is used to group the rows that have the same value. It is often used with aggregate functions for example:AVG(), MAX(), COUNT(), MIN() etc. One thing to remember about the group by clause is that the tuples are grouped based on the similarity between the attribute values of tuples.
Group By Syntax –
SELECT function_Name(column_1), column_2 FROM Table_Name WHERE condition GROUP BY column_1, column_2 ORDER BY column_1, column_2;
function_Name: Name of the aggregate function, for example:
SUM(), AVG(), COUNT() etc. Table_Name: Name of the table.
Let’s see the difference between Order by and group by clause:-
|S.NO||GROUP BY||ORDER BY|
|1.||Group by statement is used to group the rows that have the same value.||Whereas Order by statement sort the result-set either in ascending or in descending order.|
|2.||It may be allowed in CREATE VIEW statement.||While it does not use in CREATE VIEW statement.|
|3.||In select statement, it is always used before the order by keyword.||While in select statement, it is always used after the group by keyword.|
|4.||Attribute cannot be in the group by statement under aggregate function.||Whereas in order by statement, attribute can be under aggregate function.|
|5.||In group by clause, the tuples are grouped based on the similarity between the attribute values of tuples.||Whereas in order by clause, the result-set is sorted based on ascending or descending order.|
|6.||Group by controls the presentation of tuples(rows).||While order by clause controls the presentation of columns.|
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Difference between Having clause and Group by clause
- PHP | MySQL ORDER BY Clause
- Difference between Where and Having Clause in SQL
- Difference between From and Where Clause in SQL
- Difference between Where and Group By
- Difference between Security Group and Network ACL in AWS
- SQL | WITH clause
- SQL | WHERE Clause
- SQL | USING Clause
- Having vs Where Clause in SQL
- SQL | Except Clause
- SQL | ON Clause
- SQL | Union Clause
- SQL | LIMIT Clause
- SQL | Sub queries in From Clause
- SQL | Intersect & Except clause
- SQL | SELECT TOP Clause
- Having clause in MS SQL Server
- SQL | With Ties Clause
- Where clause in MS SQL Server
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
Improved By : ashushrma378