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 vote146 views1 answer
Sql value exists in column
SQL
1 vote205 views4 answers
Alter schema sql
SQL
1 vote145 views3 answers
Psql fatal database does not exist
SQL
3 votes151 views6 answers
DB::table('users')->get();
SQL
1 vote136 views1 answer
Mysql server does not start mac
SQL
0 vote139 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote145 views1 answer
Procedures sql insert mysql
SQL
0 vote157 views1 answer
Hallo
SQL
0 vote152 views1 answer
Get from database the most recent data limit by 5
SQL
24 votes132 views6 answers
Rename a column in sql server
SQL