CTE Resource Center - Verso - Database Design and Management (Oracle) Task 265083225
Describe how to write a query containing group functions.
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