MySQL GROUP BY code example
Example 1: mysql only_full_group_by
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Example 2: MySQL GROUP BY
SELECT
c1, c2,..., cn, aggregate_function(ci)
FROM
table
WHERE
where_conditions
GROUP BY c1 , c2,...,cn;
Example 3: MySQL GROUP BY
SELECT Manufacturer, COUNT(*) AS ModelsCount
FROM Products
WHERE Price > 30000
GROUP BY Manufacturer
ORDER BY ModelsCount DESC
Example 4: 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 |
+
Example 5: sql group by example
SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);