Restricting groups

You have already seen how to restrict rows in a result set using the WHERE clause. You restrict the rows in groups using the HAVING clause.

List all sales representatives with more than 55 orders

  • In Interactive SQL, execute the following query:

    SELECT SalesRepresentative, COUNT( * ) AS orders
FROM SalesOrders KEY JOIN Employees
GROUP BY SalesRepresentative
HAVING count( * ) > 55
ORDER BY orders DESC;
    SalesRepresentative orders
    299 114
    129 57
    1142 57
    467 56

See also The HAVING clause: selecting groups of data.

Combining WHERE and HAVING clauses

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0