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 votes190 views2 answers
Set value to null sql
SQL
0 vote132 views1 answer
Utiliser sql ligne de commande
SQL
2 votes137 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote137 views1 answer
Sql convert unix time to date
SQL
0 vote138 views1 answer
Plsql check for string in numeric
SQL
3 votes118 views1 answer
Sql select all
SQL
13 votes120 views6 answers
Mysql update from select
SQL
0 vote140 views1 answer
Mysql update set sum
SQL
0 vote143 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote128 views1 answer
How to select only id where is not in column mysql
SQL