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 vote213 views1 answer
Mysql database hyphen
SQL
0 vote205 views1 answer
Sql select by content lenght
SQL
1 vote173 views2 answers
Procedure pl/sql
SQL
0 vote219 views1 answer
How to convert external table to managed table in hive
SQL
0 vote245 views1 answer
Pagination with row_number
SQL
0 vote260 views1 answer
Query only first letter string
SQL
0 vote204 views1 answer
How to combine rows in sql server procedure
SQL
16 votes221 views6 answers
Python sqlite
SQL
1 vote209 views1 answer
Mysql add fields
SQL
8 votes205 views1 answer
Declare table variable sql server
SQL