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 vote365 views1 answer
Oracle locked objects
SQL
2 votes342 views1 answer
Sql create database
SQL
0 vote362 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
8 votes368 views2 answers
Replace string value in sql
SQL
0 vote352 views1 answer
Where field is null sql knex
SQL
4 votes360 views1 answer
Alter session set nls_date_format
SQL
8 votes350 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote341 views1 answer
How to find median of a column sql
SQL
7 votes372 views2 answers
Phpmyadmin change password
SQL
0 vote390 views2 answers
Wordpress change url after migration mysql query
SQL