Mysql HAVING

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 vote162 views1 answer
Sql date d'aujourd'hui
SQL
0 vote173 views1 answer
Mysql dump everythign
SQL
11 votes156 views2 answers
Insert date sql
SQL
2 votes159 views1 answer
Sql alchemy or
SQL
0 vote193 views1 answer
Postgres full text search example
SQL
13 votes163 views6 answers
Mysql update from select
SQL
37 votes212 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote168 views1 answer
Group by two columns postgres
SQL
1 vote170 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote198 views1 answer
Duplicate value unique constraint mysql error
SQL