Having in mysql

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(priceeach*quantityOrdered) AS total
FROM
    orderdetails
GROUP BY 
   ordernumber
HAVING 
   total > 1000;

Source: mysqltutorial.org

Mysql HAVING

SELECT colonne1, SUM(colonne2)
FROM nom_table
GROUP BY colonne1
HAVING fonction(colonne2) operateur valeur

Source: sql.sh

Similar codes

0 vote231 views1 answer
Get first monday of month sql
SQL
0 vote243 views3 answers
Query string not ending with with vowels
SQL
1 vote230 views1 answer
Convert to hexadecimal sql
SQL
1 vote240 views1 answer
Mysql strict_trans_tables
SQL
0 vote230 views2 answers
Mysql select date from datetime
SQL
4 votes235 views3 answers
Mysql update with join
SQL
4 votes232 views1 answer
Delete record mysql query
SQL
1 vote246 views1 answer
Rows to comma separated values in mssql
SQL
0 vote289 views1 answer
How to find unique element in sql
SQL
0 vote217 views1 answer
Sql where time stamp is in between
SQL