group or sql code example
Example 1: sql group by
+
| 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 2: select query group by name
SELECT `gender` FROM `members` GROUP BY `gender`;
Example 3: GROUP BY
SELECT <field1, field2, field3…>
FROM <table1_name>
WHERE <condition/expression>
GROUP BY <field1, field2, field3…>