What does having in mysql do?

MySQL's HAVING keyword is used after GROUP BY to filter the grouped results and select only rows that meet the specified conditions. Syntax: SELECT FROM GROUP BY HAVING It allows applying conditions to grouped columns, aggregate function results, or expressions.

The use of the HAVING keyword in MySQL

The HAVING keyword is used in MySQL in the GROUP BY subsection statement to apply the condition on the grouped data. It allows filtering of grouped results to select only rows that meet specified criteria.

Syntax

SELECT <column_list>
FROM <table_name>
GROUP BY <group_by_column>
HAVING <condition>

How to use

1. Specify grouping columns:Use GROUP BY clause specifies the columns to be grouped.
2. Add HAVING condition: After the GROUP BY clause, use HAVING to specify a condition that is used to filter the grouped results.
3. Apply conditions: HAVING conditions can be applied to grouped columns, the results of aggregate functions, or other expressions.

Example

For example, to find salespeople with sales of more than $1,000 from the "sales" table, you would use the following query:

SELECT salesperson_name, SUM(sales_amount) AS total_sales
FROM sales
GROUP BY salesperson_name
HAVING total_sales > 1000;

In this query:

• GROUP BY salesperson_name: Group salespersons by name.
• HAVING total_sales > 1000: Select only salespeople with sales over $1000.

Note:

• HAVING conditions can only refer to grouped columns and aggregate functions.
• HAVING clause is used after GROUP BY clause.
• The HAVING keyword is used to further filter the grouped results, while the WHERE keyword is used to filter the underlying data before grouping.

The above is the detailed content of What does having in mysql do?. For more information, please follow other related articles on the PHP Chinese website!