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 vote321 views1 answer
Create table as select sql server error
SQL
0 vote328 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote339 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote298 views1 answer
Including parameters in OPENQUERY
SQL
7 votes366 views1 answer
Buy forge mods server hosting
SQL
0 vote312 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote320 views1 answer
Oracle current timestamp
SQL
0 vote363 views1 answer
Tsql cte in a transaction
SQL
0 vote343 views1 answer
How to make sure two tables have same exact data in sql
SQL
5 votes329 views2 answers
Umgebungsvariable setzen für mysql 8
SQL