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 vote237 views2 answers
Sql query examples
SQL
2 votes283 views1 answer
Mysql create user with remote access
SQL
19 votes273 views5 answers
Mysql between date range
SQL
11 votes279 views2 answers
How to import mysql database command line
SQL
23 votes259 views6 answers
Delete all rows from table sql
SQL
7 votes246 views2 answers
N highest salary in sql
SQL
6 votes269 views1 answer
Wordpress change user password sql
SQL
-1 vote254 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
2 votes282 views1 answer
Postgresql update sequence next value
SQL
2 votes268 views1 answer
Mysql Incorrect column specifier for column
SQL