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

1 vote306 views1 answer
Sql server update column based on another table
SQL
1 vote303 views1 answer
Stop mysql server mac
SQL
0 vote324 views1 answer
Sql server list table sizes
SQL
10 votes293 views1 answer
Dba_dependencies
SQL
0 vote319 views1 answer
Postgresql certain first 4 characters in string
SQL
11 votes355 views1 answer
Oracle export view ddl
SQL
13 votes297 views2 answers
Display users in mysql
SQL
0 vote345 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote319 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote326 views1 answer
Ms sql print more than 1 variable
SQL