GROUP BY And ORDER BY in SQL

ORDER By in SQL and GROUP By Clause in SQL

In this SQL tutorial, we will learn how to use ORDER By and GROUP By in SQL. Group By in SQL is used to arrange similar data into groups and Order By in SQL is used to sort the data in ascending or descending order.

ORDER By in SQL

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

Syntax of ORDER By in SQL:

SELECT column1, column2….<br>
FROM table_name<br>
ORDER BY column1 ASC/DESC, column2 ASC/DESC;<br>

Become the Go-To Expert in SQL

Get Certified in SQL

Explore Program

SELECT Name<br>
FROM Student_details<br>
ORDER BY Roll_no ASC;

GROUP By in SQL:

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

The GROUP BY statement is utilized to group rows with similar values into summary rows, such as finding out the total number of Apples in each store. It is commonly combined with aggregate functions like COUNT(), MAX(), MIN(), SUM(), and AVG() to group the result set based on one or more columns.

Syntax of GROUP By in SQL:

SELECT column1, column 2…<br>
FROM table_name<br>
WHERE [condition]<br>
GROUP BY column1, column2<br>
ORDER BY column1, column2;<br>

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

SELECT Name, Sum(marks)<br>
FROM Student_details<br>
GROUP BY Name;<br>

Learn SQL with full potential with our comprehensive collection of cheat sheets, covering everything from basic concepts to advanced techniques in one convenient guide!

1. SQL Cheat Sheet
2. SQL Commands Cheat Sheet