What is the difference between HAVING and WHERE in SQL?

by

HAVING: is used to check conditions after the aggregation takes place.
WHERE: is used to check conditions before the aggregation takes place.

This code:

select City, CNT=Count(1)
From Address
Where State="MA"
Group By City

Gives you a table of all cities in MA and the number of addresses in each city.

This code:

select City, CNT=Count(1)
From Address
Where State="MA"
Group By City
Having Count(1)>5

Gives you a table of cities in MA with more than 5 addresses and the number of addresses in each city.

More Related Contents:

  1. SQL – HAVING vs. WHERE
  2. SQL JOIN – WHERE clause vs. ON clause
  3. Conditional WHERE clause in SQL Server
  4. Left Join With Where Clause
  5. Filter Table Before Applying Left Join
  6. Does the order of where clauses matter in SQL?
  7. SQL query for finding records where count > 1
  8. SQL server ignore case in a where expression
  9. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  10. Is a JOIN faster than a WHERE?
  11. What’s the difference between “where” clause and “on” clause when table left join?
  12. Mysql: how to select groups having certain values?
  13. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  14. PostgreSQL Where count condition
  15. sql query if parameter is null select all
  16. Oracle date “Between” Query
  17. How to get multiple counts with one SQL query?
  18. SQL Server, division returns zero
  19. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  20. Group by column and multiple Rows into One Row multiple columns
  21. Is it possible to output a SELECT statement from a PL/SQL block?
  22. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  23. Primary key or Unique index?
  24. Is it possible to have an indexed view in MySQL?
  25. Django select only rows with duplicate field values
  26. What are the principles behind, and benefits of, the “party model”?
  27. PostgreSQL delete with inner join
  28. Display names of all constraints for a table in Oracle SQL
  29. Zero SQL deadlock by design – any coding patterns?
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment