fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "where clause"

Tag Archives: where 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: , , , ,