| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Data Analysis - Aggregation

Page history last edited by Dr. Ron Eaglin 10 years ago

Topic - Data Analysis - Aggregation

 

We have not really looked at aggregation and aggregation function in detail yet. This week we will look at this and we will create some aggregate reports from these functions.

 

Reading

 

Aggregate Functions Reference - http://msdn.microsoft.com/en-us/library/ms173454%28v=sql.100%29.aspx 

Ranking Function Reference - http://msdn.microsoft.com/en-us/library/ms189798%28v=sql.100%29.aspx 

 

Lectures

 

Lecture - Database and Aggregations

Lecture - Advanced Query - WITH Clause

Lecture - Complex queries with aggregation

 

 

Assignments

 

COP4709 Spring 2013 Assignments - Week 9 assignment.


 

Comments (0)

You don't have permission to comment on this page.