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

1 vote120 views1 answer
Setval pgsql
SQL
3 votes106 views1 answer
What is having clause
SQL
0 vote142 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
2 votes123 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote125 views1 answer
Creation d'un trigger sql
SQL
0 vote123 views1 answer
Alter table engine mysql
SQL
0 vote124 views2 answers
Sql query inner join 3 tables
SQL
1 vote121 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
3 votes113 views3 answers
Mysql select table names
SQL
0 vote124 views1 answer
T-SQL Retry (deadlock)
SQL