Home » Posts tagged "having clause"

Tag Archives: having clause

Microsoft Access Queries: Difference Between The Where Clause And the Having Clause

Ms Access

Within the framework of using Ms Access queries, the HAVING clause can only be used with the GROUP BY type SQL statement which is also referred as the Groups and Totals query. The HAVING keyword when not used with the GROUP BY statement acts as a standard WHERE clause. The HAVING clause specifies a condition that is similar to the purpose of a WHERE clause when  applying criteria but the two clauses are not interchangeable. The key difference between these two keywords is […]

Tags: , , , ,