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

5 votes271 views3 answers
Postgres show databases
SQL
0 vote275 views1 answer
Typeorm raw sql
SQL
0 vote270 views1 answer
Sql developer search all packages for text
SQL
10 votes264 views6 answers
Mysql delete duplicates
SQL
0 vote274 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
2 votes267 views1 answer
Datetrunc
SQL
1 vote272 views1 answer
Check current sequence value postgres
SQL
0 vote281 views2 answers
Mysql dump database tables only
SQL
0 vote260 views1 answer
Sqlite to csv statement
SQL
0 vote264 views1 answer
How to check which table has data in mysql
SQL