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 vote261 views1 answer
Mysql date without time
SQL
5 votes237 views4 answers
Rollback to in sql
SQL
2 votes228 views4 answers
Sql query interview questions
SQL
0 vote267 views1 answer
Tsql cte in a transaction
SQL
0 vote215 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote223 views1 answer
Mysql command line ubuntu
SQL
0 vote227 views1 answer
Sqlite higher or equal
SQL
1 vote221 views1 answer
Mysql dump specific tables
SQL
0 vote263 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote240 views1 answer
Sql pivot table
SQL