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 vote207 views1 answer
Where field is null sql knex
SQL
1 vote179 views1 answer
Drush sql-dump
SQL
0 vote140 views1 answer
Sql count how many times a value appears
SQL
2 votes187 views2 answers
Mysql get time from datetime
SQL
0 vote198 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
2 votes204 views1 answer
Merge firstname and lastname in sql oracle
SQL
6 votes190 views1 answer
Sqlite foreign key
SQL
22 votes192 views6 answers
Create sql table
SQL
0 vote216 views1 answer
Postgres copy command
SQL
0 vote201 views1 answer
How to to get time in sql
SQL