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 vote166 views1 answer
Mysql range of dates overlap
SQL
4 votes107 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote159 views1 answer
Mysql update privileges
SQL
0 vote159 views1 answer
Oracle simple quote
SQL
3 votes178 views1 answer
Oracle undo tablespace schema
SQL
0 vote145 views1 answer
Import big data to mysql
SQL
24 votes178 views6 answers
Replace mysql
SQL
17 votes163 views3 answers
Postgresql version command
SQL
18 votes155 views2 answers
Sql inner join
SQL
0 vote154 views1 answer
Call function in query sql server
SQL