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

6 votes204 views5 answers
Oracle list tablespaces
SQL
3 votes192 views2 answers
MySQL query to get column names
SQL
0 vote197 views1 answer
Error code 1451 sql
SQL
3 votes164 views1 answer
Oracle list user grants
SQL
6 votes164 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
13 votes166 views5 answers
Alter table query sql server change column
SQL
0 vote150 views1 answer
How to create an SQL save method in ruby
SQL
0 vote212 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote167 views1 answer
Php mysqli install
SQL
0 vote277 views1 answer
Mssql unique key accept nulls
SQL