|
Author:
Author Bio:
Kathi Kellenberger, SQL Server MVP, is a DBA for Bryan Cave LLP. She is co-author of "Professional SQL Server 2005 Integration Services" (Wrox 2006), author of "Beginning T-SQL 2008" (Apress 2009), and author of several articles appearing in SQLServerCentral.com, SQLTeam.com, and SQL Server Magazine.
|
|
|
Aggregrate Queries in SQL Server T-SQL for Beginners
Want to know how to use MIN, MAX, and more? When to use HAVING versus WHERE in your queries? Join expert TSQL coach Kathi K for a great lesson on aggregate queries. Note that this video is longer than usual, about 12 minutes - well worth the time!
|
Video Information
|
Publish Date:
|
December 01, 2008
|
Length:
|
11:50
|
Skill Level:
|
100
|
Rating:
|
4.35 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- What is the difference between WHERE and HAVING?
- When using the aggregate functions SUM, COUNT, AVG, MIN, and MAX, which one(s) allow use of the asterisk?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
Nice video.can you send video about SSRS??
|
|
|
Good, basic tips for the beginner
|
|
|
Good beginners video.
|
|
|
Concepts are presented simply and clearly. Wonderful job.
|
|
|
I want more like this. This was the right level for me thanks!!!
|
|
Manish MISTRY on 5/19/2009
It needed to be shown that when you use Min And Max, it does not return the data from same row and the results in those columns may be from different rows, associated with different records!
|
|
|
the very slow pace of speaking made the speaker sound nervous.
|
|
|
Good Very Good Thanks
|
|
|
|
|
|
|