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

14 votes220 views3 answers
How to add default constraint in mysql
SQL
0 vote199 views1 answer
Mysql create table columns with spaces
SQL
7 votes203 views1 answer
Mysql remote connection command line
SQL
0 vote183 views1 answer
How to get initials in sql
SQL
7 votes199 views2 answers
MySQL IF without else
SQL
0 vote219 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
1 vote208 views1 answer
SQL: merging multiple row data in string
SQL
0 vote223 views1 answer
Postegresql update to null
SQL
0 vote218 views1 answer
Except in sql alchemy
SQL
0 vote218 views1 answer
Kotlin sqlite delete row
SQL