Difference Between Group By and Order By in SQL

MySQLDatabaseBig Data Analytics

In this post, we will understand the difference between group by and order by in SQL.

GROUP BY

  • It is used to group the rows which have the same value.

  • It can be used in CREATE VIEW statement.

  • In select statement, it has to be used before the ‘ORDER BY’ keyword.

  • Attribute can’t be in a ‘GROUP BY’ statement when it is under aggregate function.

  • The tuples are grouped based on how similar the attribute values of the tuples are.

  • It controls the presentation of the tuples/rows.

ORDER BY

  • It doesn’t use the ‘CREATE VIEW’ statement.

  • The result-set is sorted in ascending or descending order.

  • It is used after the ‘group by’ keyword.

  • The attribute can be under an aggregate function.

  • It controls the presentation of columns.

Following is the syntax of Group By and Order By in a single query −

SELECT column1, column2
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2
ORDER BY column1, column2
raja
Published on 25-Mar-2021 10:29:19
Advertisements