Sql group by

This article is tagged with: Sql group by and mysql

sql group by

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

sql group by

# Say you have a table called SALARIES that contains a
# few duplicate NAME entries...
+----+-------------+--------+
| ID | NAME | SALARY |
+----+-------------+--------+
| 1 | Bob | 500 |
| 2 | Alice | 500 |
| 3 | Alice | 200 |
| 4 | Frank | 700 |
| 5 | Percy | 100 |
| 6 | Percy | 800 |
| 7 | Cyrille | 400 |
+----+-------------+--------+
# We can obtain the total salaries of each person
# by using GROUP BY in the following query...
SELECT NAME, SALARY FROM SALARIES GROUP BY NAME;
# Which will output the following...
+------------+--------+
| Alice | 700 |
| Bob | 500 |
| Cyrille | 400 |
| Frank | 700 |
| Percy | 900 |
+------------+--------+

This article is tagged with: Sql group by and mysql