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 vote199 views1 answer
Create function in microsoft sql server
SQL
0 vote191 views1 answer
Sql server beginning of month
SQL
0 vote191 views1 answer
Mysql concatenate select results
SQL
0 vote182 views1 answer
Mysql get date diff in months
SQL
0 vote197 views1 answer
Mysqldump: error:
SQL
6 votes186 views3 answers
Date_trunc postgres
SQL
3 votes145 views1 answer
Oracle failed login attempts
SQL
1 vote162 views2 answers
String to date postgres
SQL
0 vote129 views1 answer
Check if due date is less than todays date sql
SQL
0 vote177 views1 answer
Check if has alpha characters sql
SQL