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 vote295 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote250 views1 answer
Count char in java
SQL
0 vote307 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
-1 vote308 views1 answer
Concat two columns in sql server
SQL
2 votes297 views1 answer
Sql get the name of user pc
SQL
0 vote250 views1 answer
'0000-00-00' for column '
SQL
0 vote310 views1 answer
C# mysql data reader from two tables
SQL
0 vote290 views1 answer
Oracle date summer time
SQL
0 vote341 views1 answer
Mysql relationships between tables
SQL
2 votes258 views1 answer
Latest record in sql
SQL