# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 265083227

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct code by applying a HAVING clause.

Definition

Construction should include the following:

  • A WHERE clause may still be used to limit the results used to calculate the group function.
  • The HAVING clause restricts the groups included in the GROUP BY.

Other Related Standards

Microsoft Imagine Academy Resources

[3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2

[5.037] Access 2010: Project 5