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

2 votes203 views1 answer
Oracle index size calculation
SQL
1 vote198 views1 answer
Oracle split string
SQL
0 vote193 views1 answer
Psql no such file or directory
SQL
0 vote230 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote207 views1 answer
Php get closest location by latitude longitude
SQL
0 vote200 views1 answer
Postgresql if else endif
SQL
0 vote203 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote209 views1 answer
Order by in codeigniter query builder
SQL
0 vote193 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote215 views2 answers
How to delete the rows with null values in mysql
SQL