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 vote114 views1 answer
Check if table exists oracle
SQL
0 vote136 views1 answer
How to combine rows in sql server procedure
SQL
0 vote108 views1 answer
First Step in installing SQL workbench
SQL
1 vote113 views1 answer
Postgres killing connections on db
SQL
19 votes127 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
4 votes147 views2 answers
Postgresql float data type
SQL
17 votes125 views2 answers
T_sql contains
SQL
0 vote70 views1 answer
How to see the content of tables in pgadmin
SQL
3 votes117 views2 answers
Mysql create timestamp column
SQL
5 votes120 views1 answer
Oracle nls session
SQL