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

15 votes326 views4 answers
How to get all tables in sql
SQL
0 vote320 views1 answer
How to create a table in sql stack overflow
SQL
6 votes351 views2 answers
Mysql execute file
SQL
3 votes326 views2 answers
Postgresql select all column names
SQL
1 vote308 views2 answers
Oracle replace
SQL
18 votes325 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote323 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes301 views1 answer
Plsql left() function
SQL
0 vote332 views1 answer
Function plsql
SQL
0 vote320 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL