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 vote172 views1 answer
Openquery join two tables
SQL
244 votes297 views14 answers
Sql n insert
SQL
0 vote163 views2 answers
Faster mysql imports
SQL
0 vote142 views1 answer
Mysql start of today
SQL
24 votes167 views4 answers
Mysql datetime
SQL
-1 vote161 views5 answers
Convert sql to linq query online
SQL
2 votes158 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote167 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote153 views1 answer
Oracle create as select
SQL
1 vote185 views1 answer
Top 10 rows in mysql
SQL