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 vote291 views0 answer
SQL
15 votes323 views6 answers
Drop foreign key mysql
SQL
0 vote349 views1 answer
Query to remove duplicate rows from a table
SQL
5 votes346 views2 answers
Get number of columns sql
SQL
0 vote313 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote342 views1 answer
Where name ends in SQL
SQL
4 votes324 views1 answer
Adding data to table in sql python
SQL
5 votes327 views2 answers
Copy data from one database to another
SQL
0 vote326 views1 answer
Criteria builder select subset of column
SQL
1 vote393 views1 answer
Postgresql where datetrunc month and year equal
SQL