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

24 votes96 views2 answers
Alter table delete column
SQL
0 vote101 views1 answer
What is ssrs and ssis in sql server
SQL
4 votes97 views1 answer
Search column by name mysql
SQL
4 votes113 views1 answer
Refresh postgres config
SQL
0 vote105 views1 answer
Mariadb current date plus 1 day
SQL
1 vote129 views3 answers
Sql procedure
SQL
20 votes119 views3 answers
How to open postgresql in mac
SQL
0 vote68 views1 answer
Como leer datos de mysql esp32
SQL
0 vote95 views1 answer
Mysql installer no packages found
SQL
0 vote99 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL