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

2 votes184 views1 answer
Oracle trace session
SQL
1 vote140 views2 answers
Backup table mssql
SQL
0 vote189 views1 answer
Sqlite schema structure of a relational database
SQL
10 votes145 views2 answers
Rtrim sql
SQL
1 vote134 views2 answers
Postgresql get difference in hours between two dates
SQL
18 votes156 views3 answers
Get the list of all tables in sql server
SQL
0 vote139 views1 answer
Select place default lat long
SQL
0 vote131 views1 answer
Low level operator in dbms
SQL
1 vote138 views1 answer
Type int in mysql maxlenght
SQL
2 votes151 views2 answers
Calculate percentage in sql
SQL