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 vote304 views1 answer
Sql roll up rows into columns
SQL
16 votes346 views6 answers
Python sqlite
SQL
5 votes328 views1 answer
Ora-00054 find lock
SQL
0 vote336 views1 answer
List all indexes postgres
SQL
0 vote359 views1 answer
Typical max-connect-errors mysql
SQL
0 vote336 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote332 views1 answer
Sql developer connect to sql server
SQL
0 vote323 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote308 views1 answer
Add time to date sql
SQL
0 vote311 views1 answer
On update current_timestamp jpa
SQL