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

1 vote355 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote360 views1 answer
Create table with primary key and foreign key in sql server
SQL
-1 vote328 views2 answers
On update cascade
SQL
0 vote335 views1 answer
Sql order by number not ordered
SQL
0 vote330 views1 answer
IIF
SQL
0 vote315 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote337 views1 answer
Docker open terminal mysql server
SQL
4 votes328 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote395 views1 answer
Mysql concatenate select results
SQL
6 votes354 views1 answer
Identify primary key in oracle table
SQL