Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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

For more information about the HAVING clause, see The HAVING clause: selecting groups of data.

---

Combining WHERE and HAVING clauses