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 vote150 views1 answer
Mysql create pool
SQL
0 vote157 views1 answer
What is mysql_pconnect
SQL
7 votes141 views3 answers
How to check table name in current database sql
SQL
2 votes133 views1 answer
Can you use a where clause for a child query
SQL
0 vote151 views7 answers
10 random questions use python and SQL
SQL
0 vote147 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote166 views1 answer
Create function in microsoft sql server
SQL
11 votes148 views2 answers
Oracle source code
SQL
2 votes157 views1 answer
Docker run postgres locally
SQL
0 vote144 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL