MySQL HAVING: Examples

Back Home

Examples
Sample Database

#1

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber;

#2

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber
HAVING total > 1000;

#3

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber
HAVING total > 1000 AND itemsCount > 600;

#4

SELECT 
    a.ordernumber, status, SUM(priceeach*quantityOrdered) total
FROM
    orderdetails a
        INNER JOIN
    orders b ON b.ordernumber = a.ordernumber
GROUP BY ordernumber, status
HAVING status = 'Shipped' AND total > 1500;

Table List