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

4 votes285 views3 answers
Sql drop database if exists
SQL
1 vote247 views1 answer
Mysql average of multiple columns
SQL
0 vote260 views1 answer
Increase speed of like queries postgres
SQL
0 vote264 views1 answer
Mysql preg replace
SQL
0 vote285 views1 answer
Create boolean column in MySQL with false as default value?
SQL
17 votes274 views6 answers
MySQL ORDER BY
SQL
12 votes259 views1 answer
Docker run mysql image
SQL
0 vote273 views1 answer
Intellij idea add mysql connector
SQL
0 vote256 views1 answer
Get last updated row sql server
SQL
0 vote274 views1 answer
Selecting duplicates
SQL