MySQL GROUP BY

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

The MySQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups.

The GROUP BY clause must follow the conditions in the WHERE clause and must precede the ORDER BY clause if one is used..


SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
ORDER BY column_name(s);

Let's put these statements into real use.

We've a table named Students in our database that contains the following records:

Now we will fetch records from the Students table with GROUP.

The following SQL statement lists the number of Students in GROUP SUBJECT.


 SELECT SUBJECT, Count(ROLL_NO) FROM Students 
 GROUP BY SUBJECT;

The above SELECT statement selects SUBJECT and COUNT the NUMBER for SUBJECTS from Students table.

The following SQL statement Counts the number of Students in each Subject, sorted low to High:


SELECT SUBJECT, Count(ROLL_NO) FROM Students 
GROUP BY SUBJECT
ORDER BY COUNT(ROLL_NO) ASC;

The above SELECT statement selects SUBJECT and COUNT the NUMBER for SUBJECTS from Students table and sorted low to High:

« Previous Next »

MySQL - GROUP BY