Skip to content

Instantly share code, notes, and snippets.

@sqlparser

sqlparser/having clause

Created March 25, 2014 09:24
Show Gist options
  • Save sqlparser/9758005 to your computer and use it in GitHub Desktop.
Save sqlparser/9758005 to your computer and use it in GitHub Desktop.
Download ZIP
Having clause demo code
Raw
having clause
SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders
INNER JOIN Employees
ON Orders.EmployeeID=Employees.EmployeeID)
GROUP BY LastName
HAVING COUNT(Orders.OrderID) > 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment