having group by 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: SQL group by having clause
SELECT
customer_id,
YEAR (order_date),
COUNT (order_id) order_count
FROM
sales.orders
GROUP BY
customer_id,
YEAR (order_date)
HAVING
COUNT (order_id) >= 2
ORDER BY
customer_id;
Code language: SQL (Structured Query Language) (sql)
Example 3: sql count having
SELECT COUNT( * )
FROM agents
HAVING COUNT(*)>1;
Example 4: 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);
Example 5: group by in sql
GROUP BY: is used to collaborate
with the SELECT statement to arrange
matching data into groups.
ORDER BY: is for sorting result
either in descending or ascending order.