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 vote128 views1 answer
Mysql earlier than date
SQL
2 votes140 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote170 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote136 views2 answers
Add colum in sql
SQL
0 vote145 views1 answer
Oracle c# multiple update sql
SQL
0 vote146 views1 answer
Sql select column name like from multiple tables
SQL
0 vote134 views1 answer
Get current date data in mysql
SQL
0 vote142 views1 answer
Oracle select partition
SQL
0 vote134 views1 answer
Java sql connection
SQL
0 vote132 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL