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

1 vote278 views2 answers
Reset mysqli fetch_arra
SQL
1 vote327 views1 answer
Sql server if exists update else insert
SQL
0 vote300 views1 answer
Sql server query database space available
SQL
1 vote277 views1 answer
How to print longest name in sql
SQL
0 vote282 views1 answer
Oracle get running queries
SQL
0 vote309 views1 answer
Delete record by id sql
SQL
0 vote309 views1 answer
How to query without duplicate rows in sql
SQL
-1 vote295 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote311 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote290 views1 answer
Varchar format not case sensitive sql
SQL