Order By:

It is used to sort the data in the ascending or descending order. It sorts the data in ascending order by default. To sort the data in descending order we use DESC keyword.

Syntax:

SELECT column1, column2….

FROM table_name

ORDER BY column1 ASC/DESC, column2 ASC/DESC;

Example:

Sort all the students in the descending order by the “marks” column.

SELECT Name

FROM Student_details

ORDER BY Roll_no DESC;

 

Group By:

It is used to arrange similar data into group. The GROUP BY clause follows the WHERE clause and comes before the ORDER BY clause.

Syntax:

SELECT column1, column 2…

FROM table_name

WHERE [condition]

GROUP BY column1, column2

ORDER BY column1, column2;

Example:

If we want to know the total marks of each student, then GROUP BY is used as follows:

SELECT Name, Sum(marks)

FROM Student_details

GROUP BY Name;