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

6 votes220 views1 answer
Allsource oracle
SQL
16 votes267 views6 answers
Python sqlite
SQL
0 vote299 views1 answer
Python mysql check if database exists
SQL
1 vote238 views1 answer
Postgresql create table with timestamp
SQL
0 vote188 views1 answer
Complete date is 1 year or not sql server
SQL
2 votes228 views2 answers
Calculate percentage in sql
SQL
3 votes195 views4 answers
Stop MySQL
SQL
0 vote198 views1 answer
Tsql generate rows
SQL
0 vote215 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote199 views1 answer
SQL Hello, [firstname] [lastname]
SQL