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 vote184 views1 answer
Sequelize postgresql schema
SQL
4 votes214 views2 answers
Xampp mysql database server is not starting mac m1
SQL
1 vote189 views1 answer
Xampp import sql file command line
SQL
0 vote189 views1 answer
Sql server cannot create database diagram
SQL
0 vote193 views1 answer
Oracle last character of string
SQL
0 vote211 views2 answers
Sql query for getting details by id
SQL
-2 votes253 views3 answers
How to fetch first 10 rows in sql
SQL
3 votes213 views1 answer
Start mysql server by terminal in linux
SQL
12 votes214 views5 answers
Rename table in mysql
SQL
5 votes219 views1 answer
AND OR NOT operators sql
SQL