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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct SQL code by applying a GROUP BY clause that uses column, alias, and number.

Definition

Construction should include applying a GROUP BY clause in a query that uses a group function in the SELECT statement.
  • Any column defined in the SELECT clause where a group function is used, that is NOT a group function, must be present in the GROUP BY clause.
  • The GROUP BY clause will produce sub-totals on the field defined to 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