having clause sql Example

Today, We want to share with you having clause sql.In this post we will show you sql having vs where, hear for sql having multiple conditions we will give you demo and example for implement.In this post, we will learn about SQL SELECT DISTINCT Statement with an example.

group by and having clause in sql

In this tutorial we learn to all about having Examples like as a SUM function, COUNT function, MIN function, MAX function, SQL Server HAVING or many more.

Also Read: What is the difference between a left join and a left outer join?

Query clause order

1. SELECT
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
6. ORDER BY

Using SUM function

SELECT branch, SUM(venders) AS "Total venders"
FROM request_details
GROUP BY branch
HAVING SUM(venders) > 1000;

Using COUNT function

SELECT branch, COUNT(*) AS "Number of members"
FROM members
WHERE income > 25000
GROUP BY branch
HAVING COUNT(*) > 10;

Using MIN function

SELECT branch, MIN(income) AS "Lowest income"
FROM members
GROUP BY branch
HAVING MIN(income) > 35000;

Using MAX function

SELECT branch, MAX(income) AS "Highest income"
FROM members
GROUP BY branch
HAVING MAX(income) < 50000;

SQL Server HAVING

SELECT
    member_id,
    YEAR (request_date),
    COUNT (request_id) request_count
FROM
    venders.requests
GROUP BY
    member_id,
    YEAR (request_date)
HAVING
    COUNT (request_id) >= 2
ORDER BY
    member_id;

MAX and MIN functions

SELECT
    group_id,
    MAX (list_price) max_list_price,
    MIN (list_price) min_list_price
FROM
    production.products
GROUP BY
    group_id
HAVING
    MAX (list_price) > 4000 OR MIN (list_price) < 500;

I hope you get an idea about having clause sql.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.