groupby in mysql code example
Example 1: MySQL GROUP BY
SELECT
c1, c2,..., cn, aggregate_function(ci)
FROM
table
WHERE
where_conditions
GROUP BY c1 , c2,...,cn;
Example 2: MySQL GROUP BY
SELECT Manufacturer, COUNT(*) AS ModelsCount
FROM Products
WHERE Price > 30000
GROUP BY Manufacturer
ORDER BY ModelsCount DESC
Example 3: group by sql
+
| ID | NAME | SALARY |
+
| 1 | Bob | 500 |
| 2 | Alice | 500 |
| 3 | Alice | 200 |
| 4 | Frank | 700 |
| 5 | Percy | 100 |
| 6 | Percy | 800 |
| 7 | Cyrille | 400 |
+
SELECT NAME, SALARY FROM SALARIES GROUP BY NAME;
+
| Alice | 700 |
| Bob | 500 |
| Cyrille | 400 |
| Frank | 700 |
| Percy | 900 |
+