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!

Kathi Kellenberger, is a former SQL Server MVP, who works for Microsoft in St. Louis, MO. Before joining Microsoft, she was 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 Simple-Talk.com, SQLServerCentral.com, SQLTeam.com, and SQL Server Magazi...

priti on 1/8/2009

Nice video.can you send video about SSRS??

E20CF1E7B8 on 1/8/2009

Good, basic tips for the beginner

John Barone on 1/9/2009

Good beginners video.

kin on 2/9/2009

Concepts are presented simply and clearly. Wonderful job.

matt jaroneski on 3/5/2009

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!

Dean Gross on 9/19/2009

the very slow pace of speaking made the speaker sound nervous.

A Alagu Ganesh on 9/30/2009

Good Very Good Thanks

Catto on 7/20/2010

Good Vid

Rod on 9/30/2010

I have never understood how to use the HAVING clause. Thank you!

Craig on 9/30/2010

Good summary. At the end I expected to go over what to do when you have numbers stored in text field. 2+2 numerically is 4, but 2+2 textually is 22. That leads into a discussion on using the convert function.

Indira on 9/30/2010

Very good and informative video as well as the question at the end of it.

Juri Kirillov on 9/30/2010

Thanks, Kathi - especially for NULL-related explanation!

Brent Templeton on 10/1/2010

great video, keep them up!

manik on 10/6/2010

I liked the example of avg function to be specific, where nulls make a difference. Also, it was good to know how to use a column of group by clause in the select list indirectly, like with a function.

Leon on 10/28/2010

Great demo, thx.

baghul on 6/7/2011

Excellent video Kathi! Also found some sample videos on agg functions and others here: http://www.learningsqlserver2008.com/member.htm

sushmita on 6/17/2011

good..thnx

Eric Moreau on 6/17/2011

speak faster please, it is so slow that it become boring

Tim Herrin on 6/17/2011

Thank you for this good beginner training!

Steve Harris on 6/17/2011

Very good examples. Also liked the explanation of how NULL is not considered.

Anil Babu on 6/17/2011

nice

Stephanie Brown on 6/17/2011

Very good on the basics of SQL aggregate queries. The vocal delivery is a little stilted; additional practice might help smooth that out to enhance the presentation.

Ramya Anand on 6/20/2011

It's a nice and useful video, explained in a detailed manner. Thanks

Charlie Bruno on 6/21/2011

Good refresher...!

Keith Badeau on 6/21/2011

Very thorough for a short video. Perfect intro to aggregates for a beginner. Thanks, keep them coming.

5973D3A0A2 on 6/21/2011

Good review

Cheryl on 6/22/2011

Nice, explained in very simple terms

Larry Barnes on 6/23/2011

more please

32DE12EB89 on 6/26/2011

Excellent overview and some really good tips and hints - Thanks!

Don Gilman on 6/27/2011

Added a few tools to the old toolbox.

Maurice Ivory on 11/10/2011

This one was a bit long, but it covered a lot information