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

2 votes260 views1 answer
How to show the whole table in sql
SQL
1 vote249 views1 answer
Update and replace mysql
SQL
0 vote256 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
5 votes274 views3 answers
Sql server utc to local
SQL
1 vote266 views1 answer
Where database run
SQL
8 votes261 views1 answer
Oracle tablespace datafile max size
SQL
-1 vote262 views1 answer
Capitole toulouse
SQL
4 votes254 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote252 views1 answer
Sqlite update only if greater
SQL
0 vote288 views1 answer
Sql sort ages
SQL