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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Describe how to write a query containing group functions.

Definition

Description should include the following guidelines for writing a query containing group functions:
  • DISTINCT makes the function include unique values only.
  • SELECT COUNT (DISTINCT StudentName)
  • Results are implicitly ordered in ASC (ascending) when using a GROUP BY clause. DESC (descending) order can be enforced later in an ORDER BY clause.

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